Zabbix for MySQL: item( Query Time Count 00....)

参考文章：

https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html

Zabbix监控MySQL，有几个监控项不是太明白，专门研究了一下。

监控项如下：

以上几个监控项监控的是MySQL Query Response Time

Percona官方介绍：

Query responsetime distribution is a feature available in Percona Server. It providesinformation about changes in query response time for different groups ofqueries, often allowing to spot performance problems before they lead toserious issues.

安装QUERY_RESPONSE_TIME 插件：

mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME_AUDIT SONAME 'query_response_time.so';

mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME 'query_response_time.so';

mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME_READ SONAME 'query_response_time.so';

mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME_WRITE SONAME 'query_response_time.so';

 安装后查看：

设置query_response_time_stats 参数：

mysql> SET GLOBAL query_response_time_stats=ON;

使用

SELECT * from INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;

或者

SELECT c.count, c.time,
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0; 

注意：

此功能会导致非常高的开销，尤其是在每秒超过10 000次查询的系统上。仅在解决问题时临时使用它。