MySQL 5.1 Reference Manual :: 4 MySQL Programs :: 4.6 MySQL Administrative and Utility Programs :: 4.6.8 mysqldumpslow — Summarize Slow Query Log Files shell> mysqldumpslow [options] [log_file ...]
mysqldumpslow supports the following options.
Table 4.12. mysqldumpslow Options
FormatOption FileDescription
-aDo not abstract all numbers to N and strings to S
-n numAbstract numbers with at least the specified digits
--debugdebugWrite debugging information
-g patternOnly consider statements that match the pattern
--helpDisplay help message and exit
-h nameHost name of the server in the log file name -i nameName of the server instance
-lDo not subtract lock time from total time
-rReverse the sort order
-s valueHow to sort output
-t numDisplay only first num queries
--verboseverboseVerbose mode
--help
Display a help message and exit.
-a
Do not abstract all numbers to N and strings to 'S'.
--debug, -d
Run in debug mode.
-g pattern
Consider only queries that match the (grep-style) pattern.
-h host_name
Host name of MySQL server for *-slow.log file name. The value can contain a wildcard. The default is * (match all).
-i name
Name of server instance (if using mysql.server startup script).
-l
Do not subtract lock time from total time.
-n N
Abstract numbers with at least N digits within names.
-r
Reverse the sort order.
-s sort_type
How to sort the output. The value of sort_type should be chosen from the following list:
t, at: Sort by query time or average query time
l, al: Sort by lock time or average lock time
r, ar: Sort by rows sent or average rows sent
c: Sort by count
By default, mysqldumpslow sorts by average query time (equivalent to -s at).
-t N
Display only the first N queries in the output.
--verbose, -v
Verbose mode. Print more information about what the program does.
Example of usage:
#按执行次数进行排序
shell> mysqldumpslow -t 5 -s c mysqld51-apple-slow.log
Reading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log
Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1 limit N
Count: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t1 select * from t1
Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1