-
Problem report
-
Resolution: Commercial support required
-
Trivial
-
None
-
None
-
None
Hello, Am using zabbix Version 5.0.38 with MySQL 8.0.35.
For last few days am seeing spikes in DB load Avg which is causing slowness in UI and sometimes wheel getting spinned up for large time then error contact zabbix administrator. When checked DB logs and process list there are few queries which is taking much time to execution which results in spike in DB load avg. Slowness is observed only for user and admin role not for super admin access.
SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p,functions f,items i,hosts_groups hg 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 (35,36,41) 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.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (1245,1325,1548) AND p.severity IN (4,5) AND p.acknowledged=0 AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1705458955) ORDER BY p.eventid DESC LIMIT 501
Not sure what these queries are trying to look but I suspect these queries are from dashboard or problem tab which is causing spike in load avg.
Attached screenshot and long running sessions for ref.
- duplicates
-
ZBXNEXT-5878 Enhance permission checking/handling
-
- Closed
-