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

Optimize database queries in trigger event processing

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.0.17
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None

      Description

      When processing trigger events server loads all open problems associated to triggers with new OK events. This is done in following steps:

      1. select all open problems for the specified triggers
      2. select tags of all elected problems

      From similar experience the (2) step can be quite slow on Oracle databases. It might be worth optimizing it by merging both steps by joining tag query to the first query.

        Attachments

          Activity

            People

            Assignee:
            zabbix.dev Zabbix Development Team
            Reporter:
            wiper Andris Zeila
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: