from small one page howto to huge articles all in one place
Last additions:
May 25th. 2007:
April, 26th. 2006:
| 
MYSQLDUMPSLOW
Section: MySQL Database System (1) Updated: 12/11/2025 Index
Return to Main Contents
NAME
mysqldumpslow - Summarize slow query log files
SYNOPSIS
-
mysqldumpslow [options] [log_file ...]
DESCRIPTION
The MySQL slow query log contains information about queries that take a long time to execute (see
Section 7.4.5, lqThe Slow Query Logrq).
mysqldumpslow
parses MySQL slow query log files and summarizes their contents.
Normally,
mysqldumpslow
groups queries that are similar except for the particular values of number and string data values. It
lqabstractsrq
these values to
N
and
'S'
when displaying summary output. To modify value abstracting behavior, use the
-a
and
-n
options.
Invoke
mysqldumpslow
like this:
-
mysqldumpslow [options] [log_file ...]
Example output with no options given:
-
Reading mysql slow query log from /usr/local/mysql/data/mysqld80-slow.log
Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1
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
mysqldumpslow
supports the following options.
-
*
--help
Display a help message and exit.
-
*
-a
Do not abstract all numbers to
N
and strings to
'S'.
-
*
--debug,
-d
|
Comman-Line Format
| -debug
|
Run in debug mode.
This option is available only if MySQL was built using
WITH_DEBUG. MySQL release binaries provided by Oracle are
not
built using this option.
-
*
-g pattern
Consider only queries that match the (grep-style) pattern.
-
*
-h host_name
|
Type
|
String
|
|
Default Value
|
*
|
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
|
Type
|
String
|
|
Default Value
|
at
|
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
|
Comman-Line Format
| -verbose
|
Verbose mode. Print more information about what the program does.
COPYRIGHT
Copyright © 1997, 2025, Oracle and/or its affiliates.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 0211-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual,
which may already be installed locally and which is also available
online at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- COPYRIGHT
-
- SEE ALSO
-
- AUTHOR
-
| 
|
|
- Running on 
-
:
