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

Slow query for Monitoring Problem usser type zabbix user

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 5.0.25
    • None
    • Frontend (F)
    • None

    Description

      We experience slow query for monitoring-> problems for user type zabbix user and zabbix admin, for zabbix superadmin no issue.

      We detected that query is different and times much longer for zabbix user
      zabbix user query  13.62 seconds
      SQL (13.621241): SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (42,86) WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND p.severity IN (3,4) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1661340198) ORDER BY p.eventid DESC LIMIT 5001

      zabbix superadmin user query 0.11 seconds
      SQL (0.119617): SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND p.severity IN (3,4) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1661340841) AND p.clock>='1661254742' ORDER BY p.eventid DESC LIMIT 5001

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            Verbo Carlos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: