[ZBX-4929] slow select SQL query on Monitoring -> Graphs Created: 2012 Apr 27 Updated: 2017 May 30 Resolved: 2012 Jun 29 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 1.8.12 |
Fix Version/s: | 1.8.15rc1, 2.0.2rc1, 2.1.0 |
Type: | Incident report | Priority: | Trivial |
Reporter: | Kodai Terashima | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | graphs, performance, permissions | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: | graph queries.png | ||||||||
Issue Links: |
|
Description |
Time:9.713475 LONG SQL: SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE ((g.groupid BETWEEN 100000000000000 AND 199999999999999)) AND hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status=0 AND EXISTS( SELECT DISTINCT i.itemid FROM items i, graphs_items gi WHERE i.hostid=hg.hostid AND i.itemid=gi.itemid) |
Comments |
Comment by Eduards Samersovs (Inactive) [ 2012 May 08 ] |
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4929 |
Comment by Toms (Inactive) [ 2012 May 08 ] |
(1) Queries became slower. Results in image. <Eduard> RESOLVED, I hope LIMIT will helps <Toms> CLOSED |
Comment by Toms (Inactive) [ 2012 Jun 29 ] |
TESTED |
Comment by Eduards Samersovs (Inactive) [ 2012 Jun 29 ] |
Fixed in versions pre-1.8.15rc1 r28578, pre-2.0.2rc1 r28584, 2.1.0 r28585 |