1 Topic by Emma2 (edited by Emma2 2023-04-26 14:37:56)

  • Emma2
  • Member
  • Offline
  • Registered: 2019-09-25
  • Posts: 21

Topic: [SOLVED] "mysql_local.connections_active" ratio is "too big"

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.0 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? n.n.
- Linux/BSD distribution name and version: Ubuntu 18.04.6 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

For some time, I keep getting this warning:
mysql_local.connections_active Chart
mysql connections = 70.2%
the ratio of current active connections vs the maximum possible number of connections Alarm

After a short time, my system "recovers", but I guess it would be a good idea to solve the issue instead.
Should I increase the number of allowed connections? An how would I do this?
Or is this a more serious problem? (BTW: I am the only one using the server right now, and I am doing this with three or four clients simultaneously, 2 Linuxs and 2 Androids.)

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by Emma2

  • Emma2
  • Member
  • Offline
  • Registered: 2019-09-25
  • Posts: 21

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

Noone here to tell me how and where to set this limit to a higher number?

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,131

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

Please describe with more / enough details so that others can help.

Where did you get this "warning"?

4 Reply by Emma2 (edited by Emma2 2023-04-24 21:32:18)

  • Emma2
  • Member
  • Offline
  • Registered: 2019-09-25
  • Posts: 21

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

Several time a day, I receive an email:

netdata notification
<name of my server> needs attention
mysql_local.connections_active Chart
mysql connections = 73.5%
the ratio of current active connections vs the maximum possible number of connections Alarm
connections Family
WARNING Severity
Wed Apr 12 13:24:44 UTC 2023 Time
$this > (($status >= $WARNING) ? (60) : (70)) Evaluated Expression
[ $this = 73.5099338 ] [ $status = 1 ] [ $WARNING = 3 ] Expression Variables
The host has 1 WARNING and 0 CRITICAL alarm(s) raised.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,131

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

- netdata alert is a little sensitive.
- You can increase max connections in mariadb (my.cnf) to "fix" this "issue".

6 Reply by Emma2 (edited by Emma2 2023-04-25 15:18:45)

  • Emma2
  • Member
  • Offline
  • Registered: 2019-09-25
  • Posts: 21

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

I cannot find such a file in /opt/mysql nor /opt/mariadb.
Would /root/iRedMail-0.9.9/samples/mysql/my.cnf be the correct one to do that change?
Or is it /etc/mysql/my.cnf? Or rather /etc/alternatives/my.cnf?
Unfortunately, I am not an expert for this...

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,131

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

Emma2 wrote:

I cannot find such a file in /opt/mysql nor /opt/mariadb.

FYI https://docs.iredmail.org/file.locations.html#mysql

8 Reply by Emma2

  • Emma2
  • Member
  • Offline
  • Registered: 2019-09-25
  • Posts: 21

Re: [SOLVED] "mysql_local.connections_active" ratio is "too big"

Thank you! With your help, I could locate it.
On my machine, it is actually in file /etc/mysql/mariadb.conf.d/50-server.cnf