The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.2.5, “The Slow Query Log” ). mysqldumpslow parses MySQL slow query log files and prints a summary of their contents.
Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It “abstracts ” these values to N
and 'S'
when displaying summary output. The -a
and -n
options can be used to modify value abstracting behavior.
Invoke mysqldumpslow like this:
shell>mysqldumpslow [
options
] [log_file
...]
mysqldumpslow supports the following options.
Table 4.12. mysqldumpslow
Options
Format | Config File | Description | Introduction | Deprecated | Removed |
---|---|---|---|---|---|
-a | Do not abstract all numbers to N and strings to S | ||||
-n num | Abstract numbers with at least the specified digits | ||||
--debug | debug | Write debugging information | |||
-g pattern | Only consider statements that match the pattern | ||||
--help | Display help message and exit | ||||
-h name | Host name of the server in the log file name | ||||
-i name | Name of the server instance | ||||
-l | Do not subtract lock time from total time | ||||
-r | Reverse the sort order | ||||
-s value | How to sort output | ||||
-t num | Display only first num queries | ||||
--verbose | verbose | Verbose mode |
-
Display a help message and exit.
-
Do not abstract all numbers to
N
and strings to'S'
. -
--debug
,-d
Run in debug mode.
-
Consider only queries that match the (grep -style) pattern.
-
Host name of MySQL server for
*-slow.log
file name. The value can contain a wildcare. The default is*
(match all). -
Name of server instance (if using mysql.server startup script).
-
Do not subtract lock time from total time.
-
Abstract numbers with at least
N
digits within names. -
Reverse the sort order.
-
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 -
s
,as
: Sort by rows sent or average rows sent -
c
: Sort by count
-
-
Display only the first
N
queries in the output. -
--verbose
,-v
Verbose mode. Print more information about what the program does.