zabbix出现慢查询
zabbix_server.log11010:20160526:111835.474 slow query: 4.457534 sec, "commit;"
11008:20160526:111837.031 slow query: 4.706924 sec, "commit;"
11004:20160526:111837.032 slow query: 3.565452 sec, "commit;"
10982:20160526:111838.834 Zabbix agent item "system.users.num" on host "Zabbix server" failed: first network error, wait for 15 seconds
10985:20160526:111854.988 resuming Zabbix agent checks on host "Zabbix server": connection restored
11010:20160526:111930.442 slow query: 4.751124 sec, "commit;"
11008:20160526:111934.191 slow query: 3.746949 sec, "commit;"
11006:20160526:111938.325 item "Zabbix server:system.users.num" became not supported: Not supported by Zabbix Agent
11006:20160526:112834.167 item "Zabbix server:system.users.num" became supported
11006:20160526:112900.219 slow query: 3.361220 sec, "commit;"
11008:20160526:113039.851 slow query: 4.014440 sec, "insert into history_uint (itemid,clock,ns,value) values (23674,1464233434,500146703,99297280),(23314,1464233434,510506687,3);
"
11010:20160526:113039.851 slow query: 3.482697 sec, "insert into history (itemid,clock,ns,value) values (23255,1464233435,500957797,0.000000);
出现慢查询是要优化数据库么还是这是跟机器的性能有关？一开始都没有出现这个问题的。 zabbix mysql数据库优化一下吧
参考文档
https://www.zabbix.org/wiki/Docs/howto/mysql_partition
页:
[1]