Zabbix is built with container and server version is 5.0.24.
DB is using AWS RDS (mysql8.0).
If we build multiple zabbix servers, we will run out of RDS connections. (Current max connections = 61)
Basically, the number of connections from zabbix-server to DB is 25~35. Is there any way to reduce this?
I know how to increase the max number of DB connections, but what I want to know is how to reduce the number of connections from zabbix to db.

DB is using AWS RDS (mysql8.0).
If we build multiple zabbix servers, we will run out of RDS connections. (Current max connections = 61)
Basically, the number of connections from zabbix-server to DB is 25~35. Is there any way to reduce this?
I know how to increase the max number of DB connections, but what I want to know is how to reduce the number of connections from zabbix to db.
HTML Code:
mysql> show processlist; +-----+-----------------+---------------------+-------------+---------+------+------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-----------------+---------------------+-------------+---------+------+------------------------+------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1850 | Waiting on empty queue | NULL | | 12 | rdsadmin | localhost:38868 | NULL | Sleep | 8 | | NULL | | 72 | zabbix | 10.11.100.135:30890 | zabbix50000 | Sleep | 44 | | NULL | | 74 | zabbix | 10.11.100.135:30914 | zabbix50000 | Sleep | 8 | | NULL | | 75 | zabbix | 10.11.100.135:30924 | zabbix50000 | Sleep | 11 | | NULL | | 76 | zabbix | 10.11.100.135:30940 | zabbix50000 | Sleep | 5 | | NULL | | 77 | zabbix | 10.11.100.135:30952 | zabbix50000 | Sleep | 125 | | NULL | | 78 | zabbix | 10.11.100.135:30956 | zabbix50000 | Sleep | 4 | | NULL | | 79 | zabbix | 10.11.100.135:30962 | zabbix50000 | Sleep | 7 | | NULL | | 80 | zabbix | 10.11.100.135:30972 | zabbix50000 | Sleep | 9 | | NULL | | 81 | zabbix | 10.11.100.135:30988 | zabbix50000 | Sleep | 8 | | NULL | | 82 | zabbix | 10.11.100.135:31002 | zabbix50000 | Sleep | 1 | | NULL | | 83 | zabbix | 10.11.100.135:31022 | zabbix50000 | Sleep | 2 | | NULL | | 84 | zabbix | 10.11.100.135:31026 | zabbix50000 | Sleep | 10 | | NULL | | 85 | zabbix | 10.11.100.135:31006 | zabbix50000 | Sleep | 12 | | NULL | | 86 | zabbix | 10.11.100.135:31038 | zabbix50000 | Sleep | 3 | | NULL | | 87 | zabbix | 10.11.100.135:31042 | zabbix50000 | Sleep | 6 | | NULL | | 88 | zabbix | 10.11.100.135:31052 | zabbix50000 | Sleep | 44 | | NULL | | 89 | zabbix | 10.11.100.135:31064 | zabbix50000 | Sleep | 3 | | NULL | | 90 | zabbix | 10.11.100.135:31072 | zabbix50000 | Sleep | 164 | | NULL | | 91 | zabbix | 10.11.100.135:31086 | zabbix50000 | Sleep | 2 | | NULL | | 92 | zabbix | 10.11.100.135:31098 | zabbix50000 | Sleep | 164 | | NULL | | 93 | zabbix | 10.11.100.135:31106 | zabbix50000 | Sleep | 148 | | NULL | | 94 | zabbix | 10.11.100.135:31112 | zabbix50000 | Sleep | 164 | | NULL | | 95 | zabbix | 10.11.100.135:31116 | zabbix50000 | Sleep | 164 | | NULL | | 96 | zabbix | 10.11.100.135:31130 | zabbix50000 | Sleep | 149 | | NULL | | 97 | zabbix | 10.11.100.135:31136 | zabbix50000 | Sleep | 159 | | NULL | | 98 | zabbix | 10.11.100.135:31140 | zabbix50000 | Sleep | 164 | | NULL | | 100 | zabbix | 10.11.100.135:31158 | zabbix50000 | Sleep | 164 | | NULL | | 101 | zabbix | 10.11.100.135:31152 | zabbix50000 | Sleep | 164 | | NULL | | 102 | zabbix | 10.11.100.135:31172 | zabbix50000 | Sleep | 164 | | NULL | | 103 | zabbix | 10.11.100.135:31180 | zabbix50000 | Sleep | 164 | | NULL | | 104 | zabbix | 10.11.100.135:31186 | zabbix50000 | Sleep | 1 | | NULL | | 105 | zabbix | 10.11.100.135:31188 | zabbix50000 | Sleep | 61 | | NULL | | 106 | zabbix | 10.11.100.135:31204 | zabbix50000 | Sleep | 62 | | NULL | | 120 | admin | 10.11.0.187:32822 | NULL | Query | 0 | init | show processlist | +-----+-----------------+---------------------+-----------------+---------+------+--------------------+------------------+
Comment