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

Huge load on database if a trigger expression contains a user macro

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.7rc1, 2.1.0
    • 2.1.2
    • Server (S)

    Description

      When history syncer tries to evaluate a trigger expression it makes a SQL query to database which selects all unique hostid related to the trigger.
      The query is performed for each trigger having a user macro.

      We should use cache instead of SQL queries in this case.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: