MySQL Query Killing IO
HI there, just for a reference - 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 |
| 35394 | zabbix | localhost | zabbix | Query | 0 | NULL | commit |
| 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.
| 35388 | zabbix | localhost | zabbix | Query | 46 | Sorting result | select value from history_text where itemid=51881 order by id desc limit 1 |
| 35394 | zabbix | localhost | zabbix | Query | 0 | NULL | commit |
| 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.