Hi guys
I'm getting problem in my enronment.
I'm having a lot of problems to retreive data...
The Zabbix is extremely slow. After debug, I've found the slowest query.
-------+---------+---------+----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+----------------+-------------
29921 | zabbix | 3252 | 29920 | zabbix | SELECT DISTINCT e.eventid,e.clock FROM events e,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE e.object=0 AND f.triggerid=e.objectid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=101 AND r.permission>=2 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=e.objectid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=101 AND rr.permission<2)) AND ((e.eventid BETWEEN 000000000000000 AND 099999999999999)) AND e.clock>=1330713630 AND e.clock<=1331318430 ORDER BY e.clock DESC LIMIT 1001 OFFSET 0 | f | 2012-03-09 15:40:30.4395-03 | 2012-03-09 15:40:30.4395-03 | 2012-03-09 15:38:27.401005-03 | 10.192.127.212 | 55467
29921 | zabbix | 3253 | 29920 | zabbix | SELECT DISTINCT e.eventid,e.clock FROM events e,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE e.object=0 AND f.triggerid=e.objectid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=5 AND r.permission>=2 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=e.objectid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=5 AND rr.permission<2)) AND ((e.eventid BETWEEN 000000000000000 AND 099999999999999)) AND e.clock>=1330713630 AND e.clock<=1331318430 ORDER BY e.clock DESC LIMIT 1001 OFFSET 0 | f | 2012-03-09 15:40:30.440625-03 | 2012-03-09 15:40:30.440625-03 | 2012-03-09 15:38:29.419025-03 | 10.192.127.212 | 55470
(2 rows)
My Zabbix status is: (I've got more than 5 minuts to get Status of Zabbix)
Zabbix server is running Yes localhost:10051
Number of hosts (monitored/not monitored/templates) 521 481 / 16 / 24
Number of items (monitored/disabled/not supported) 19150 13236 / 3364 / 2550
Number of triggers (enabled/disabled)[problem/unknown/ok] 3642 2967 / 674 [49 / 169 / 2749]
Number of users (online) 97 6
Required server performance, new values per second 82.67 -
My Zabbix Server version is 1.8.5
I'm using Postgres 8.4
Any help will be appreciated a lot.
best regards
Leandro
I'm getting problem in my enronment.
I'm having a lot of problems to retreive data...
The Zabbix is extremely slow. After debug, I've found the slowest query.
-------+---------+---------+----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+----------------+-------------
29921 | zabbix | 3252 | 29920 | zabbix | SELECT DISTINCT e.eventid,e.clock FROM events e,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE e.object=0 AND f.triggerid=e.objectid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=101 AND r.permission>=2 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=e.objectid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=101 AND rr.permission<2)) AND ((e.eventid BETWEEN 000000000000000 AND 099999999999999)) AND e.clock>=1330713630 AND e.clock<=1331318430 ORDER BY e.clock DESC LIMIT 1001 OFFSET 0 | f | 2012-03-09 15:40:30.4395-03 | 2012-03-09 15:40:30.4395-03 | 2012-03-09 15:38:27.401005-03 | 10.192.127.212 | 55467
29921 | zabbix | 3253 | 29920 | zabbix | SELECT DISTINCT e.eventid,e.clock FROM events e,functions f,items i,hosts_groups hg,rights r,users_groups ug WHERE e.object=0 AND f.triggerid=e.objectid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=5 AND r.permission>=2 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=e.objectid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=5 AND rr.permission<2)) AND ((e.eventid BETWEEN 000000000000000 AND 099999999999999)) AND e.clock>=1330713630 AND e.clock<=1331318430 ORDER BY e.clock DESC LIMIT 1001 OFFSET 0 | f | 2012-03-09 15:40:30.440625-03 | 2012-03-09 15:40:30.440625-03 | 2012-03-09 15:38:29.419025-03 | 10.192.127.212 | 55470
(2 rows)
My Zabbix status is: (I've got more than 5 minuts to get Status of Zabbix)
Zabbix server is running Yes localhost:10051
Number of hosts (monitored/not monitored/templates) 521 481 / 16 / 24
Number of items (monitored/disabled/not supported) 19150 13236 / 3364 / 2550
Number of triggers (enabled/disabled)[problem/unknown/ok] 3642 2967 / 674 [49 / 169 / 2749]
Number of users (online) 97 6
Required server performance, new values per second 82.67 -
My Zabbix Server version is 1.8.5
I'm using Postgres 8.4
Any help will be appreciated a lot.
best regards
Leandro