Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-3588

Improve Multiple Event Condition Evaluation

    XMLWordPrintable

Details

    • Team A
    • Sprint 2, Sprint 3, Sprint 4, Sprint 5, Sprint 6, Sprint 7, Sprint 8, Sprint 9, Sprint 10, Sprint 11, Sprint 12, Sprint 13, Sprint 14, Sprint 15, Sprint 16, Sprint 17, Sprint 18, Sprint 19, Sprint 20, Sprint 21, Sprint 22, Sprint 23, Sprint 64 (May 2020), Sprint 65 (Jun 2020)
    • 10

    Description

      Now in ZBXNEXT-3086 we acquire unique conditions hash set. This helps to avoid same condition double checking per event.
      However this can be improved even further by bulk selects if there are more than one event at a time.
      After unique conditions are acquired it is possible to run through all unique conditions and do bulk select for all events instead of just one.

      It is expected that after optimization the query count will be equal to conditions.
      Before optimization query count is equal to condition * events.

      Attachments

        1. not_optimized_all_trigger_conditions_2017-06-21 17-17-06.png
          201 kB
          Vladislavs Sokurenko
        2. not_optimized_trigger_sources_2016-12-28 13-12-15.png
          179 kB
          Vladislavs Sokurenko
        3. optimized_trigger_sources_2016-12-28 13-08-25.png
          178 kB
          Vladislavs Sokurenko
        4. optimzed_all_trigger_conditions_2017-06-21 17-13-19.png
          196 kB
          Vladislavs Sokurenko
        5. zabbix_server_log_drules-1.png
          49 kB
          Edgar Akhmetshin

        Issue Links

          Activity

            People

              vso Vladislavs Sokurenko
              vso Vladislavs Sokurenko
              Votes:
              4 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: