Optimize database queries in trigger event processing

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 4.0.17
    • Component/s: 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.

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

              Created:
              Updated: