-
Incident report
-
Resolution: Fixed
-
Blocker
-
None
-
3.0.23
-
None
-
centos 6.5 /8core/16G mysql and zabbix server location different servert
Steps to reproduce:
- Due to business requiremets, i upgrade zabbix mysql from 5.1 to mysql-community-server-5.7.17
Result:
mysql server cpu load too high, the i check zabbix server log, it have no errors. My Teams DBA found some SQL like blow take up a lot of CPU.
SELECT clock,ns,VALUE FROM history_uint WHERE itemid=1809973 AND clock>1548387847 AND clock<=1548388147 ORDER BY clock DESC LIMIT 1
But when we do not use "ORDER BY clock DESC LIMIT 1" , it's run fast. Thanks for your support
Expected:
See screenshot....
See attached patch file...