-
Problem report
-
Resolution: Incomplete
-
Trivial
-
None
-
5.0.25
-
None
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