2
.\" Title: \fBmysqldumpslow\fR
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
.\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
6
.\" Manual: MySQL Database System
10
.TH "\FBMYSQLDUMPSLOW\FR" "1" "09/09/2013" "MySQL 5\&.5" "MySQL Database System"
11
.\" -----------------------------------------------------------------
12
.\" * Define some portability stuff
13
.\" -----------------------------------------------------------------
14
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15
.\" http://bugs.debian.org/507673
16
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20
.\" -----------------------------------------------------------------
21
.\" * set default formatting
22
.\" -----------------------------------------------------------------
23
.\" disable hyphenation
25
.\" disable justification (adjust text to left margin only)
27
.\" -----------------------------------------------------------------
28
.\" * MAIN CONTENT STARTS HERE *
29
.\" -----------------------------------------------------------------
32
mysqldumpslow \- Summarize slow query log files
34
.HP \w'\fBmysqldumpslow\ [\fR\fBoptions\fR\fB]\ [\fR\fB\fIlog_file\fR\fR\fB\ \&.\&.\&.]\fR\ 'u
35
\fBmysqldumpslow [\fR\fBoptions\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB \&.\&.\&.]\fR
38
The MySQL slow query log contains information about queries that take a long time to execute (see
39
Section\ \&5.2.5, \(lqThe Slow Query Log\(rq)\&.
41
parses MySQL slow query log files and prints a summary of their contents\&.
45
groups queries that are similar except for the particular values of number and string data values\&. It
51
when displaying summary output\&. The
55
options can be used to modify value abstracting behavior\&.
65
shell> \fBmysqldumpslow [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB \&.\&.\&.]\fR
72
supports the following options\&.
82
.\" mysqldumpslow: help option
83
.\" help option: mysqldumpslow
86
Display a help message and exit\&.
99
Do not abstract all numbers to
113
.\" mysqldumpslow: debug option
114
.\" debug option: mysqldumpslow
129
\fB\-g \fR\fB\fIpattern\fR\fR
131
Consider only queries that match the (\fBgrep\fR\-style) pattern\&.
142
\fB\-h \fR\fB\fIhost_name\fR\fR
144
Host name of MySQL server for
146
file name\&. The value can contain a wildcard\&. The default is
159
\fB\-i \fR\fB\fIname\fR\fR
161
Name of server instance (if using
176
Do not subtract lock time from total time\&.
187
\fB\-n \fR\fB\fIN\fR\fR
189
Abstract numbers with at least
191
digits within names\&.
204
Reverse the sort order\&.
215
\fB\-s \fR\fB\fIsort_type\fR\fR
217
How to sort the output\&. The value of
219
should be chosen from the following list:
230
at: Sort by query time or average query time
242
al: Sort by lock time or average lock time
254
ar: Sort by rows sent or average rows sent
270
sorts by average query time (equivalent to
282
\fB\-t \fR\fB\fIN\fR\fR
284
Display only the first
286
queries in the output\&.
297
.\" mysqldumpslow: verbose option
298
.\" verbose option: mysqldumpslow
302
Verbose mode\&. Print more information about what the program does\&.
311
shell> \fBmysqldumpslow\fR
312
Reading mysql slow query log from /usr/local/mysql/data/mysqld51\-apple\-slow\&.log
313
Count: 1 Time=4\&.32s (4s) Lock=0\&.00s (0s) Rows=0\&.0 (0), root[root]@localhost
314
insert into t2 select * from t1
315
Count: 3 Time=2\&.53s (7s) Lock=0\&.00s (0s) Rows=0\&.0 (0), root[root]@localhost
316
insert into t2 select * from t1 limit N
317
Count: 3 Time=2\&.13s (6s) Lock=0\&.00s (0s) Rows=0\&.0 (0), root[root]@localhost
318
insert into t1 select * from t1
326
Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
328
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.
330
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.
332
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 02110-1301 USA or see http://www.gnu.org/licenses/.
335
For more information, please refer to the MySQL Reference Manual,
336
which may already be installed locally and which is also available
337
online at http://dev.mysql.com/doc/.
339
Oracle Corporation (http://dev.mysql.com/).