Type: Incident report
Affects Version/s: 3.0.23
Fix Version/s: None
Component/s: Server (S)
Environment: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
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.
But when we do not use "ORDER BY clock DESC LIMIT 1" , it's run fast. Thanks for your support
See attached patch file...