Poor performance zabbix DB

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Trivial
    • None
    • Affects Version/s: 5.0.2
    • Component/s: None
    • None

      I have zabbix-server 5.02 installed on CentOS7 x64 and MySQL-server (mysql 5.7.30) on different server with CentOS7.
      Gradually, the zabbix-server runs out of RAM. I noticed that this is proportional to how the number of read requests and row locks on the mysql-server. Is there a known issue with this version of Zabbix?
      If you need to provide config files or some kind of logs, please inform.
      Below are 2 screenshots of mysql-server monitoring.

        1. InnoDB_Buffer.png
          InnoDB_Buffer.png
          68 kB
        2. Queries_and_row_lock.png
          Queries_and_row_lock.png
          78 kB
        3. zbx-graph-1.png
          zbx-graph-1.png
          150 kB
        4. zbx-graph-10.png
          zbx-graph-10.png
          43 kB
        5. zbx-graph-2.png
          zbx-graph-2.png
          121 kB
        6. zbx-graph-3.png
          zbx-graph-3.png
          24 kB
        7. zbx-graph-4.png
          zbx-graph-4.png
          47 kB
        8. zbx-graph-5.png
          zbx-graph-5.png
          132 kB
        9. zbx-graph-6.png
          zbx-graph-6.png
          91 kB
        10. zbx-graph-7.png
          zbx-graph-7.png
          70 kB
        11. zbx-graph-8.png
          zbx-graph-8.png
          159 kB
        12. zbx-graph-9.png
          zbx-graph-9.png
          84 kB

            Assignee:
            Zabbix Support Team
            Reporter:
            Kirill Guskov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: