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

Monitoring->triggers page is too slow on systems with a lot of triggers because of seq scan of triggers table

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.0.7rc1, 2.1.0
    • Frontend (F)
    • MySQL

      We get triggers in PROBLEM state (value = 1) and triggers in OK state (value = 0 AND clock>= NOW() - INTERVAL 30 MINUTES). We have no index by clock column for triggers table. So this query can take a lot of time.

            Unassigned Unassigned
            dotneft Alexey Pustovalov
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: