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

Optimize database queries in trigger event processing

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 4.0.17
    • Server (S)
    • None

      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.

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

              Created:
              Updated: