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

Low performance in WEB-interface: "Monitoring" -> "Triggers" with high number active triggers.

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 2.4.2, 2.4.3, 2.4.4
    • Fix Version/s: None
    • Component/s: API (A), Frontend (F)
    • Labels:
    • Environment:
      DB soft: 10.0.15-MariaDB-wsrep-log for Linux on x86_64
      DB hard: Intel Xeon E5-2650 x2 / RAM 64Gb / LSI MR9271-8i, Cache 1Gb, RAID-10 / HDD SAS 600Gb x4
      PHP: PHP 5.4.5
      HTTPD: Apache/2.2.22

      Description

      Low performance in WEB-interface: "Monitoring" -> "Triggers" with high number active triggers. Refresh time for interface in 1-2min.

      Total Host in configuration: 4340
      Total Item: 859481
      Total Trigger: 406991

      Active triggers for different Hostgroup:
      >40 - refresh time 20sec
      >90 - refresh time 30sec
      >700 - refresh time 1:30min
      >900 - refresh time 1:40min

      Partitioning on DB is active. Active history for 1 month.

      Long query after SQL builder (API):
      Start: 2015-02-24 12:17:12

      SELECT t.triggerid,t.lastchange FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('121','125','126','128','129') WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND EXISTS (SELECT NULL FROM events e WHERE t.triggerid=e.objectid AND e.source=0 AND e.object=0 AND e.value=1 AND e.acknowledged=0) AND t.flags IN ('0','4') AND ((t.value=1) OR ((t.value=0) AND (t.lastchange>1424772852))) ORDER BY t.lastchange DESC
      

      End : 2015-02-24 12:18:51

      For additional info please see file in attach (explain and profile file make in different time).

        Attachments

        1. 2015.02.23. 1 Dashboard.jpg
          2015.02.23. 1 Dashboard.jpg
          209 kB
        2. 2015.02.23. 1 Long Query Proc.jpg
          2015.02.23. 1 Long Query Proc.jpg
          512 kB
        3. 2015.02.23. 2 Trigger Display + Filter.jpg
          2015.02.23. 2 Trigger Display + Filter.jpg
          294 kB
        4. 2015.02.24. 4 Current CPU load.jpg
          2015.02.24. 4 Current CPU load.jpg
          106 kB
        5. 2015.02.24. 5 Current memory load.jpg
          2015.02.24. 5 Current memory load.jpg
          86 kB
        6. CTrigger.php
          65 kB
        7. CTrigger.php
          65 kB
        8. DB_config.txt
          15 kB
        9. HW_config.txt
          0.3 kB
        10. patch
          6 kB
        11. patch.diff
          6 kB
        12. SB_explain.txt
          4 kB
        13. SB_profiles.txt
          3 kB
        14. SB_profiles1.txt
          31 kB
        15. WB_sql.txt
          6 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gdgsoft Dmitrij Gavrilenko
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: