graph queries.png
|
Duplicate |
|||
| is duplicated by |
|
Slow graph dropdowns in "Monitoring" ... | Closed |
[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 |