zabbix出現(xiàn)慢查詢

ydzcjj

zabbix_server.log

11010: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);

出現(xiàn)慢查詢是要優(yōu)化數(shù)據(jù)庫么還是這是跟機(jī)器的性能有關(guān)？一開始都沒有出現(xiàn)這個(gè)問題的。

yoyosys

zabbix mysql數(shù)據(jù)庫優(yōu)化一下吧  
參考文檔
https://www.zabbix.org/wiki/Docs/howto/mysql_partition