Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-24321

Zabbix server slow query

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • None
    • Proxy (P), Server (S)
    • None

      Hello!
      Since we implemented the Zabbix Proxies in our Zabbix environment, we are experiencing slow queries to the DB (Oracle) every time the RefreshActiveChecks of the Zabbix Proxies are executed.
      As you can see in the image we have around 15,000 nodes in the Proxy, and I have the feeling that as a result of the slow query a queue is also being generated in the processing of the Zabbix Proxy items.
      The Zabbix Proxy is only responsible for executing icmping and icmppingsec on each of the 15,000 nodes.

      Thanks.

        1. image-2024-04-05-13-20-25-649.png
          image-2024-04-05-13-20-25-649.png
          2 kB
        2. image-2024-04-05-13-24-22-193.png
          image-2024-04-05-13-24-22-193.png
          11 kB
        3. slow_query.txt
          149 kB
        4. zabbix_proxy.conf.txt
          28 kB

            azyla Arkadiusz Zyla
            illanagu Iván Llana Guevara
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: