Loading...

XML

Word

Printable

It appears that the used query:

select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc,ns desc limit 2;

This works in many times faster:

select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc limit 2;

Please look the screenshots for details.

is duplicated by

ZBX-8886 MySQL server stalls whenever disabled items in zabbix are re-enabled after relatively short periods of time

ZBX-8731 Missing index in history_uint table slows zabbix server to a complete stop.