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

Slow query on events list page on partitioned db

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 2.0.12, 2.2.4
    • Frontend (F)

      Zabbix events page tries to get oldest event to make slider bar or zoom period.

      That query is quite heavy on partitioned db

      • the db has lots of events
      • using Zabbix user or Zabbix admin that are only have permission to hosts are just added on partitioned db (target events are located only latest partition)

      The problem happens to see events page with guest user that doesn't have any permission ( need to search all events table for not-existing events)

            Unassigned Unassigned
            kodai Kodai Terashima
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: