Mysql-SlowLog-analysis

Mysql-SlowLog-analysis copied to clipboard

最近在使用pt-query-digest分析慢查，将结果保存到表中，但让人困惑的是，为什么有的语句ts_cnt字段有值，有的却是null值，源码看了会，由于是perl写的，看不明白

jandison

[INFO]>> 生成Json报告 Traceback (most recent call last): File "./analysis-slow-log.py", line 166, in res_json_report = obj.general_json_slow_log_report() File "./analysis-slow-log.py", line 117, in general_json_slow_log_report query_tables = slow_query_sql['tables'] KeyError: 'tables' You have mail in...

qq516249940

====开始分析慢查询日志==== slow.log: 1% 00:52 remain slow.log: 20% 00:07 remain slow.log: 39% 00:04 remain slow.log: 57% 00:02 remain slow.log: 75% 00:01 remain slow.log: 93% 00:00 remain [INFO]>> 生成Json报告 Traceback (most recent...

kobeng

Binjjam

求教

3

转化成json文件，然后再解析一遍，效率怎么样？你怎么保证实时刷新呢

jiahong787