当前连接数 | mysql_global_status_threads_connected | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘threads_connected’; |
最大连接数 | mysql_global_variables_max_connections | 登录 mysql,执行 SQL \n SHOW VARIABLES LIKE ‘max_connections’; |
MYSQL 缓存命中率 | mysql_global_status_qcache_hits 和 mysql_global_status_commands_total{command=~“select”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS \n LIKE ‘Qcache_hits’; \n SHOW GLOBAL STATUS LIKE ‘Com_select’; |
InnoDB 缓存命中率 | mysql_global_status_innodb_buffer_pool_reads \n mysql_global_status_innodb_buffer_pool_read_requests | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_buffer_pool_reads%’; \n SHOW GLOBAL STATUS LIKE ‘Innodb_buffer_pool_read_request%’; |
MYISAM 缓存命中率 | mysql_global_status_key_reads 和 mysql_global_status_key_read_requests | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Key_reads%’; \n SHOW GLOBAL STATUS LIKE ‘Key_read_requests%’; |
CPU 使用率 | container_cpu_usage_seconds_total 和 kube_pod_container_resource_limits | k8s 集群 master 机器执行 \n kubectl top pod -n coding | grep mariadb-primary,核对 use 是否一致 \n kubectl get pod mariadb-primary-0 -n coding -o=jsonpath=‘{.spec.containers[*].resources.limits.memory}’ 核对 limit 是否一致 |
内存占用 | container_memory_usage_bytes | k8s 集群 master 机器执行 \n kubectl top pod -n coding | grep mariadb-primary,核对 use 是否一致 |
内存利用率 | container_memory_usage_bytes 和 kube_pod_container_resource_limits{resource=“memory”,unit=“byte”} | k8s 集群 master 机器执行 \n kubectl top pod -n coding | grep mariadb-primary,核对 use 是否一致 \n kubectl get pod mariadb-primary-0 -n coding -o=jsonpath=‘{.spec.containers[*].resources.limits.cpu}’ 核对 limit 是否一致 |
发送数据量 | mysql_global_status_bytes_sent | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Bytes_received’; |
接受数据量 | mysql_global_status_bytes_received | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Bytes_sent’; |
所有SQL语句,无论其是否执行成功 | mysql_global_status_queries | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Queries’; |
慢查询数 | mysql_global_status_slow_queries | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Slow_queries’; |
全表查询数 | mysql_global_status_select_scan | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Select_scan’; |
执行 DELETE 查询的次数 | mysql_global_status_commands_total{command=~“delete”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Com_delete’; |
执行 INSERT 查询的次数 | mysql_global_status_commands_total{command=~“insert”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Com_insert’; |
执行 UPDATE 查询的次数 | mysql_global_status_commands_total{command=~“update”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Com_update’; |
执行 REPLACE 查询的次数 | mysql_global_status_commands_total{command=~“replace”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Com_replace’; |
执行 SELECT 查询的次数 | mysql_global_status_commands_total{command=~“select”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Com_select’; |
现场运行数 | mysql_global_status_threads_running | 登录 mysql,执行 SQL \n SHOW STATUS LIKE ‘Threads_running’; |
线程创建数 | mysql_global_status_threads_created | 登录 mysql,执行 SQL \n SHOW STATUS LIKE ‘Threads_created’; |
InnoDB 磁盘写次数 \n 单位: 次/s | mysql_global_status_innodb_data_writes | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘innodb_data_writes’; \n 或者 \n SHOW ENGINE INNODB STATUS; 查看 OS file writes 一行 |
InnoDB 磁盘读次数 \n 单位: 次/s | mysql_global_status_innodb_data_reads | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘innodb_data_reads’; \n 或者 \n SHOW ENGINE INNODB STATUS; 查看 OS file reads 一行 |
InnoDB 磁盘 fsync 次数 \n 单位: 次/s | mysql_global_status_innodb_data_fsyncs | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘innodb_data_fsyncs’; \n 或者 \n SHOW ENGINE INNODB STATUS; 查看 OS fsyncs 一行 |
InnoDB 读取的数据量 \n 单位: 字节/s | mysql_global_status_innodb_data_reads | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_data_reads’; |
InnoDB 写入的数据量 \n 单位: 字节/s | mysql_global_status_innodb_data_writes | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_data_written’; |
InnoDB行删除量 | mysql_global_status_innodb_row_ops_total{operation=“deleted”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_rows_deleted’; |
InnoDB行插入量 | mysql_global_status_innodb_row_ops_total{operation=“inserted”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_rows_inserted’; |
InnoDB行读取量 | mysql_global_status_innodb_row_ops_total{operation=“read”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_rows_read’; |
InnoDB行更新量 | mysql_global_status_innodb_row_ops_total{operation=“updated”} | 登录 mysql,执行 SQL \n SHOW GLOBAL STATUS LIKE ‘Innodb_rows_updated’; |