Ad Widget

Collapse

Change number of basic DB connections for zabbix

Collapse
This topic has been answered.
X
X
 
  • Time
  • Show
Clear All
new posts
  • poco
    Junior Member
    • Jan 2023
    • 1

    #1

    Change number of basic DB connections for zabbix

    ​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.​
    ​​​​​​​Click image for larger version

Name:	スクリーンショット 2023-01-12 19.22.50.png
Views:	498
Size:	5.3 KB
ID:	457486
    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 |
    +-----+-----------------+---------------------+-----------------+---------+------+--------------------+------------------+​
    Last edited by poco; 13-01-2023, 07:32.
  • Answer selected by poco at 14-01-2023, 16:54.
    Hamardaban
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • May 2019
    • 2713


    StartDBSyncers ?
    StartODBCPoller ?

    Comment


    • poco
      poco commented
      Editing a comment
      I used StartDBSyncers
      As a result, I found that it can be reduced to 25->21.
      Thank you.
  • Hamardaban
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • May 2019
    • 2713

    #2

    StartDBSyncers ?
    StartODBCPoller ?

    Comment


    • poco
      poco commented
      Editing a comment
      I used StartDBSyncers
      As a result, I found that it can be reduced to 25->21.
      Thank you.
Working...