-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Major
-
None
-
Affects Version/s: 1.8.4
-
Component/s: Server (S)
-
Environment:Centos 5.5, innodb, mysql,
Queries on 1.8.4 like these are killing out systems CPU wait I/O and undamentally the performance of the whole system
| 35388 | zabbix | localhost | zabbix | Query | 46 | Sorting result | select value from history_text where itemid=51881 order by id desc limit 1 |
| 35408 | zabbix | localhost | zabbix | Query | 84 | Sorting result | select value from history_text where itemid=51481 order by id desc limit 1 |
| 35459 | zabbix | localhost | zabbix | Query | 82 | Sorting result | select value from history_text where itemid=52466 order by id desc limit 1 |
I am however not able to fully find the source of the queries, however it is probably not the PHP frontend, since when I shut the zabbix server the queries die.