Hi
Large amount of items are very slow to display in items.php.
My host is a network switch and as more than 1200 items.
The display of the first page is very slow more than one minute.
The only fix I found is to limit the display in this page (by the zabbix configuration page) and then filter by name, key name etc.
I use zabbix 2.2.1 on a VM zabbix server (4proc/8Gb Ram), database is a percona 5.6.
With zabbix 2.0.X I have no trouble.
I made some "show processlist" it seems that itemps.php do a query like "SELECT * FROM history_uint h WHERE h.itemid='XXXX' ORDER BY h.clock DESC LIMIT 2 OFFSET 0" for each items of the host event though the items are not displayed (The query is fast 0.2s).
Do you have any idea?
regards
Martin
Large amount of items are very slow to display in items.php.
My host is a network switch and as more than 1200 items.
The display of the first page is very slow more than one minute.
The only fix I found is to limit the display in this page (by the zabbix configuration page) and then filter by name, key name etc.
I use zabbix 2.2.1 on a VM zabbix server (4proc/8Gb Ram), database is a percona 5.6.
With zabbix 2.0.X I have no trouble.
I made some "show processlist" it seems that itemps.php do a query like "SELECT * FROM history_uint h WHERE h.itemid='XXXX' ORDER BY h.clock DESC LIMIT 2 OFFSET 0" for each items of the host event though the items are not displayed (The query is fast 0.2s).
Do you have any idea?
regards
Martin