MySQL状态诊断工具
推荐：
MySQL my.cnf生成工具
有任何使用问题或意见反馈，请加QQ群：
125572178
，感谢支持哈 :)
扫码关注「老叶茶馆」公众号
所有都是必填项，请您填写完整信息，谢谢！
您的姓名
您的邮箱
您的QQ或微信ID或手机号
您的MySQL版本
MySQL 5.6系列
MySQL 5.7系列
MySQL 8.0系列
请在此粘贴运行下面命令
mysqladmin ext | sed 's/[ ][ ]*//ig' | egrep -iv '\-\-\-|Variable_name'
并做格式化处理过后的结果
内容格式参考如下（不是这种格式的暂时无法识别处理哦）： | Aborted_clients | 209 | | Aborted_connects | 4 | | Acl_cache_items_count | 0 | | Audit_log_buffer_size_overflow | 1560 | | Binlog_snapshot_file | mgr01.000073 | | Binlog_snapshot_position | 1039476903 | | Binlog_cache_disk_use | 9 | | Binlog_cache_use | 12181233 | | Binlog_snapshot_gtid_executed | not-in-consistent-snapshot | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 19 |
请在此粘贴运行下面命令
mysqladmin pr | sed 's/[ ][ ]*//ig' | egrep -iv '\-\-\-|Id.*User.*Host'
并做格式化处理过后的结果
内容格式参考如下（不是这种格式的暂时无法识别处理哦）： | 7 | event_scheduler | localhost | | Daemon | 758073 | Waiting on empty queue | | 758072403 | 0 | 0 | | 12 | system user | | | Connect | 758023 | waiting for handler commit | Group replication applier module | 758022671 | 0 | 0 | | 14 | system user | | | Query | 69381 | Replica has read all relay log; waiting for more updates | | 69380346 | 0 | 0 | | 15 | system user | | | Connect | 758023 | Waiting for an event from Coordinator | | 69380346 | 0 | 0 | | 16 | system user | | | Connect | 758023 | Waiting for an event from Coordinator | | 758022662 | 0 | 0 | | 17 | system user | | | Connect | 758023 | Waiting for an event from Coordinator | | 758022662 | 0 | 0 | | 18 | system user | | | Connect | 758023 | Waiting for an event from Coordinator | | 758022661 | 0 | 0 | | 1300 | GreatSQL | 192.168.5.160:55704 | | Sleep | 218 | | | 217798 | 0 | 0 | | 1301 | GreatSQL | 192.168.5.160:55706 | | Sleep | 214 | | | 213564 | 1 | 6 | | 1302 | root | localhost | tpch | Query | 36 | waiting for handler commit | load /*+ SET_VAR(gdb_parallel_load=OFF) */ data infile '/data/tpch/data/customer.tbl' into table cus | 35394 | 0 | 0 | | 1322 | root | localhost | | Query | 0 | init | show processlist | 0 | 0 | 0 |
您还有什么想对老叶说的吗
ChangeLog:
2023.07.01, v1.0.0 上线
TODO:
1. 支持SHOW ENGINE INNODB STATUS结果分析