连接和线程指标

# 当前连接数
mysql_global_status_threads_connected

# 最大连接数
mysql_global_variables_max_connections

# 连接使用率
mysql_global_status_threads_connected / mysql_global_variables_max_connections * 100

# 连接错误数
rate(mysql_global_status_connection_errors_total[5m])

查询性能指标

# QPS(每秒查询数)
rate(mysql_global_status_queries[5m])

# TPS(每秒事务数)
rate(mysql_global_status_questions[5m])

# 慢查询数
rate(mysql_global_status_slow_queries[5m])

# 查询缓存命中率
mysql_global_status_qcache_hits / (mysql_global_status_qcache_hits + mysql_global_status_qcache_inserts) * 100

复制状态指标

# 主从延迟
mysql_slave_status_seconds_behind_master

# 复制IO线程状态
mysql_slave_status_slave_io_running

# 复制SQL线程状态
mysql_slave_status_slave_sql_running

# 复制错误数
mysql_slave_status_last_io_errno

缓冲区和表状态

# InnoDB缓冲池命中率
(1 - mysql_global_status_innodb_buffer_pool_reads / mysql_global_status_innodb_buffer_pool_read_requests) * 100

# 表锁等待
rate(mysql_global_status_table_locks_waited[5m])

# 行锁等待
rate(mysql_global_status_innodb_row_lock_waits[5m])