test

gistfile1.txt

grafana模板化

SELECT mean("value") FROM "Momysql_value" WHERE "host" = 'mysqltest' AND "type_instance" = 'bytes_received' AND $timeFilter GROUP BY time($__interval) fill(null)

 

SELECT mean("value") FROM "Momysql_value" WHERE "host" =~ /^$host$/ AND "type_instance" = 'bytes_received' $timeFilter GROUP BY time($__interval), "host"

 

 

percona模板区别

innodb change buffer     ：mysql_global_status_innodb_ibuf_segment_size 标准mysql没有这个参数

innodb change buffer activity ：mysql_global_status_innodb_ibuf_merges 标准mysql没有这个参数

 

Index Condition Pushdown : mysql_info_schema_innodb_metrics_icp_icp_attempts_total标准mysql没有这个参数

 

innodb deadlock  :

mysql_global_status_innodb_deadlocks

mysql_info_schema_innodb_metrics_lock_lock_deadlocks_total 标准mysql没有这个参数

 

innodb checkpoint age :

mysql_global_status_innodb_checkpoint_age

mysql_global_status_innodb_checkpoint_max_age  标准mysql没有这个参数

 

mysql overview的监控指标