mysqldumpslow
— Summarize Slow Query Log Files
350
•
Master Pos
: The position of the next event in the original master log file.
•
Flags
: 16 flags. Currently, the following flags are used. The others are reserved for future use.
Flag Name
Meaning
01
LOG_EVENT_BINLOG_IN_USE_F
Log file correctly closed. (Used only in
FORMAT_DESCRIPTION_EVENT
.)
If this flag is set (if the flags are, for example,
'01 00'
) in a
FORMAT_DESCRIPTION_EVENT
, the log file has not been properly closed.
Most probably this is because of a master crash (for example, due to
power failure).
02
Reserved for future use.
04
LOG_EVENT_THREAD_SPECIFIC_F
Set if the event is dependent on the connection it was executed in (for
example,
'04 00'
), for example, if the event uses temporary tables.
08
LOG_EVENT_SUPPRESS_USE_F
Set in some circumstances when the event is not dependent on the default
database.
4.6.8.
mysqldumpslow
— Summarize Slow Query Log Files
The MySQL slow query log contains information about queries that take a long time to execute (see
Section 5.2.4, “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.11.
mysqldumpslow
Options
Format
Option File
Description
-a [350]
Do not abstract all numbers to N and strings to S
-n num [351]
Abstract numbers with at least the specified digits
--debug [351]
debug [351]
Write debugging information
-g pattern [351]
Only consider statements that match the pattern
--help [350]
Display help message and exit
-h name [351]
Host name of the server in the log file name
-i name [351]
Name of the server instance
-l [351]
Do not subtract lock time from total time
-r [351]
Reverse the sort order
-s value [351]
How to sort output
-t num [351]
Display only first num queries
--verbose [351]
verbose [351]
Verbose mode
•
--help
[350]
Display a help message and exit.
•
-a
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...