[root@mysql01 data]# /usr/local/mysql/bin/mysqldumpslow --help 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 |