1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
.\" Title: \fBmysqldumpslow\fR
.\" Author:
.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/>
.\" Date: 03/31/2009
.\" Manual: MySQL Database System
.\" Source: MySQL 5.1
.\"
.TH "\fBMYSQLDUMPSLOW\fR" "1" "03/31/2009" "MySQL 5.1" "MySQL Database System"
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.SH "NAME"
mysqldumpslow \- Summarize slow query log files
.SH "SYNOPSIS"
.HP 39
\fBmysqldumpslow [\fR\fBoptions\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB ...]\fR
.SH "DESCRIPTION"
.PP
The MySQL slow query log contains information about queries that take a long time to execute (see
Section\ 5.2.5, \(lqThe Slow Query Log\(rq).
\fBmysqldumpslow\fR
parses MySQL slow query log files and prints a summary of their contents.
.PP
Normally,
\fBmysqldumpslow\fR
groups queries that are similar except for the particular values of number and string data values. It
\(lqabstracts\(rq
these values to
N
and
\'S'
when displaying summary output. The
\fB\-a\fR
and
\fB\-n\fR
options can be used to modify value abstracting behavior.
.PP
Invoke
\fBmysqldumpslow\fR
like this:
.sp
.RS 3n
.nf
shell> \fBmysqldumpslow [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIlog_file\fR\fR\fB ...]\fR
.fi
.RE
.PP
\fBmysqldumpslow\fR
supports the following options:
.TP 3n
\(bu
\fB\-\-help\fR
.sp
Display a help message and exit.
.TP 3n
\(bu
\fB\-a\fR
.sp
Do not abstract all numbers to
N
and strings to
\'S'.
.TP 3n
\(bu
\fB\-\-debug\fR,
\fB\-d\fR
.sp
Run in debug mode.
.TP 3n
\(bu
\fB\-g \fR\fB\fIpattern\fR\fR
.sp
Consider only queries that match the (\fBgrep\fR\-style) pattern.
.TP 3n
\(bu
\fB\-h \fR\fB\fIhost_name\fR\fR
.sp
Host name of MySQL server for
\fI*\-slow.log\fR
file name. The value can contain a wildcare. The default is
*
(match all).
.TP 3n
\(bu
\fB\-i \fR\fB\fIname\fR\fR
.sp
Name of server instance (if using
\fBmysql.server\fR
startup script).
.TP 3n
\(bu
\fB\-l\fR
.sp
Do not subtract lock time from total time.
.TP 3n
\(bu
\fB\-n \fR\fB\fIN\fR\fR
.sp
Abstract numbers with at least
\fIN\fR
digits within names.
.TP 3n
\(bu
\fB\-r\fR
.sp
Reverse the sort order.
.TP 3n
\(bu
\fB\-s \fR\fB\fIsort_type\fR\fR
.sp
How to sort the output. The value of
\fIsort_type\fR
should be chosen from the following list:
.RS 3n
.TP 3n
\(bu
t,
at: Sort by query time or average query time
.TP 3n
\(bu
l,
al: Sort by lock time or average lock time
.TP 3n
\(bu
s,
as: Sort by rows sent or average rows went
.TP 3n
\(bu
c: Sort by count
.RE
.TP 3n
\(bu
\fB\-t \fR\fB\fIN\fR\fR
.sp
Display only the first
\fIN\fR
queries in the output.
.TP 3n
\(bu
\fB\-\-verbose\fR,
\fB\-v\fR
.sp
Verbose mode. Print more information about what the program does.
.sp
.RE
.PP
Example of usage:
.sp
.RS 3n
.nf
shell> \fBmysqldumpslow\fR
Reading mysql slow query log from /usr/local/mysql/data/mysqld51\-apple\-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
.fi
.RE
.SH "COPYRIGHT"
.PP
Copyright 2007\-2008 MySQL AB, 2009 Sun Microsystems, Inc.
.PP
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.
.PP
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.
.PP
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/.
.SH "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/.
.SH AUTHOR
MySQL AB (http://www.mysql.com/).
|
