querydigest

MySQL slow query log analyzer.

This project is very limited version of pt-query-digest.

Getting Started

Prerequisites

• Go 1.12+

Installing

$ go get -u github.com/akito0107/querydigest/cmd/querydigest

How To Use

$ querydigest -f path/to/slow_query_log

then, summaries appear as below:

Query 0
51.103328%

Summary:
total query time:	107.51s
total query count:	2969

\+--------------+---------+------+-------+------+------+--------+--------+
| ATTRIBUTE    |   TOTAL |  MIN |   MAX |  AVG |  95% | STDDEV | MEDIAN |
\+--------------+---------+------+-------+------+------+--------+--------+
| Exec Time    |    108s | 13us |    3s | 36ms | 83ms |  218ms |  293us |
| Lock Time    |     27s |  0us | 926ms |  9ms | 27ms |   55ms |   27us |
| Rows Sent    | 1417.00 | 0.00 |  2.00 | 0.48 | 1.00 |   0.54 |   0.00 |
| Rows Examine | 2834.00 | 0.00 |  4.00 | 0.95 | 2.00 |   1.08 |   0.00 |
\+--------------+---------+------+-------+------+------+--------+--------+

Query_time distribution:
  1us:
 10us:	###########################################
100us:	###########################################################################
  1ms:	###############################
 10ms:	########################################
100ms:	#####
   1s:	#
 10s~:

QueryExample:
select * from example_table;


Query 1
10.935321%

Summary:
total query time:	23.01s
total query count:	2469

\+--------------+-------+-------+-------+------+------+--------+--------+
| ATTRIBUTE    | TOTAL |   MIN |   MAX |  AVG |  95% | STDDEV | MEDIAN |
\+--------------+-------+-------+-------+------+------+--------+--------+
| Exec Time    |   23s | 119us | 349ms |  9ms | 47ms |   21ms |    2ms |
| Lock Time    |    4s |  10us | 101ms |  2ms | 11ms |    7ms |   23us |
| Rows Sent    |  0.00 |  0.00 |  0.00 | 0.00 | 0.00 |   0.00 |   0.00 |
| Rows Examine |  0.00 |  0.00 |  0.00 | 0.00 | 0.00 |   0.00 |   0.00 |
\+--------------+-------+-------+-------+------+------+--------+--------+

Query_time distribution:
  1us:
 10us:
100us:	####################################################################
  1ms:	###########################################################################
 10ms:	###################################
100ms:	#
   1s:
 10s~:

QueryExample:
select * from example_table2;

.....

By default, querydigest analyzes and shows all queries from given slow query log. If you want to display only top n items, please use -n option.

$ querydigest -f path/to/slow_query_log -n 10

Limitations

Currently, querydigest can't parse and analyze all queries supported by MySQL. These queries are excluded from analysis.

All statistics are approximate value, and there are no guarantee of accuracy.

Options

$ querydigest -help
Usage of bin/querydigest:
  -f string
    	slow log filepath (default "slow.log")
  -j int
    	concurrency (default = num of cpus)
  -n int
    	count

License

This project is licensed under the Apache License 2.0 License - see the LICENSE file for details