- 论坛徽章:
- 12
|
就是在zabbix_server.log中经常会有一些慢查询的log
22645:20160531:103656.026 slow query: 30.592515 sec, "commit;"
22646:20160531:103656.346 slow query: 29.710860 sec, "commit;"
22644:20160531:103656.347 slow query: 28.710691 sec, "commit;"
22647:20160531:103656.347 slow query: 27.669053 sec, "commit;"
22641:20160531:103656.347 slow query: 5.946819 sec, "commit;"
22644:20160531:103830.658 slow query: 60.149027 sec, "commit;"
就这些一直卡着导致某些监控项的变成not supported 然后等这些慢查询过了之后又会重新support ,可以知道这是在做什么么?还是数据库需要优化,目前只有十几台机器 |
|