[ZBX-14622] Slow queries and delay loading Dashboard Created: 2018 Jul 18  Updated: 2018 Aug 06  Resolved: 2018 Aug 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.4.11
Fix Version/s: None

Type: Problem report Priority: Minor
Reporter: Craig Hopkins Assignee: Unassigned
Resolution: Commercial support required Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Steps to reproduce:

Either loading or the dashboard or when it auto-refreshes. 

Result:

Page takes several seconds to load

Zabbix Server log has 

16367:20180718:131510.105 slow query: 4.580088 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.state,t.lastchange,t.status,t.recovery_mode,t.recovery_expression,t.correlation_mode,t.correlation_tag from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"
16367:20180718:131514.750 slow query: 4.186808 sec, "select distinct tt.triggertagid,tt.triggerid,tt.tag,tt.value from trigger_tag tt,triggers t,hosts h,items i,functions f where t.triggerid=tt.triggerid and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=tt.triggerid and h.status in (0,1)"

 Comments   
Comment by Craig Hopkins [ 2018 Jul 18 ]

In case it helps:

Number of hosts (enabled/disabled/templates)	739	617 / 22 / 100
Number of items (enabled/disabled/not supported)	97474	91120 / 1996 / 4358
Number of triggers (enabled/disabled [problem/ok])	83329	75603 / 7726 [92 / 75511]
Comment by Edgar Akhmetshin [ 2018 Jul 19 ]

Hello, Craig

Thank you for contacting Zabbix.  Unfortunately this problem looks like a database or hardware performance issue.

You can try to perform this steps to check, for example:

  • add 'LogSlowQueries=3000' and 'DebugLevel=4' to the zabbix_server.conf under /etc/zabbix-server directory and restart a process;
  • use 'iostat' utility to check HDD/SSD performance (key points iowait/svctime/iops);
  • if your database size is bigger then 100GB use partitioning https://zabbix.org/wiki/Docs/howto/mysql_partition;

For available support options see http://zabbix.org/wiki/Getting_help.
Closing as Won't fix/Commercial support required.

Generated at Wed Nov 05 20:45:53 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.