mysql慢查日志分析工具：自带的mysqldumpslow

root@ubuntu:~# mysqldumpslow -h

Option h requires an argument

ERROR: bad option

Usage: mysqldumpslow [ OPTS... ] [ LOGS... ]

Parse and summarize the MySQL slow query log. Options are

  --verbose    verbose

  --debug      debug

  --help       write this text to standard output

  -v           verbose

  -d           debug

  -s ORDER     what to sort by (al, at, ar, c, l, r, t), 'at' is default

                al: average lock time

                ar: average rows sent

                at: average query time

                 c: count

                 l: lock time

                 r: rows sent

                 t: query time  

  -r           reverse the sort order (largest last instead of first)

  -t NUM       just show the top n queries

  -a           don't abstract all numbers to N and strings to 'S'

  -n NUM       abstract numbers with at least n digits within names

  -g PATTERN   grep: only consider stmts that include this string

  -h HOSTNAME  hostname of db server for *-slow.log filename (can be wildcard),

               default is '*', i.e. match all

  -i NAME      name of server instance (if using mysql.server startup script)

  -l           don't subtract lock time from total time

 

root@ubuntu:~# mysqldumpslow -t 6 /var/lib/mysql/mysql_slow_20170829.log 

Reading mysql slow query log from /var/lib/mysql/mysql_slow_20170829.log

Count: 3  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.7 (5), root[root]@localhost

  show variables like 'S'

Count: 3  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.7 (5), root[root]@localhost

  select * from store limit N

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@localhost

  select @@version_comment limit N

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost

  set global slow_query_log_file='S'

Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=7.0 (14), root[root]@localhost

  show databases

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), root[root]@localhost

  SELECT DATABASE()

root@ubuntu:~#