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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.0.7rc1, 2.1.0
    • Fix Version/s: None
    • Component/s: Frontend (F)
    • Environment:
      MySQL

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: