Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.1 Reference Manual  / ...  / MySQL Programs  / Administrative and Utility Programs  /  mysqldumpslow — Summarize Slow Query Log Files

6.6.10 mysqldumpslow — Summarize Slow Query Log Files

The MySQL slow query log contains information about queries that take a long time to execute (seeSection 7.4.5, “The Slow Query Log”).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“abstracts” these values toN and'S' when displaying summary output. To modify value abstracting behavior, use the-a and-n options.

Invokemysqldumpslow like this:

mysqldumpslow [options] [log_file ...]

Example output with no options given:

Reading mysql slow query log from /usr/local/mysql/data/mysqld91-slow.logCount: 1  Time=4.32s (4s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1Count: 3  Time=2.53s (7s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 limit NCount: 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.

Table 6.21 mysqldumpslow Options

Option NameDescription
-aDo not abstract all numbers to N and strings to 'S'
-nAbstract numbers with at least the specified digits
--debugWrite debugging information
-gOnly consider statements that match the pattern
--helpDisplay help message and exit
-hHost name of the server in the log file name
-iName of the server instance
-lDo not subtract lock time from total time
-rReverse the sort order
-sHow to sort output
-tDisplay only first num queries
--verboseVerbose mode

  • --help

    Command-Line Format--help

    Display a help message and exit.

  • -a

    Do not abstract all numbers toN and strings to'S'.

  • --debug,-d

    Command-Line Format--debug

    Run in debug mode.

    This option is available only if MySQL was built usingWITH_DEBUG. MySQL release binaries provided by Oracle arenot built using this option.

  • -gpattern

    TypeString

    Consider only queries that match the (grep-style) pattern.

  • -hhost_name

    TypeString
    Default Value*

    Host name of MySQL server for*-slow.log file name. The value can contain a wildcard. The default is* (match all).

  • -iname

    TypeString

    Name of server instance (if usingmysql.server startup script).

  • -l

    Do not subtract lock time from total time.

  • -nN

    TypeNumeric

    Abstract numbers with at leastN digits within names.

  • -r

    Reverse the sort order.

  • -ssort_type

    TypeString
    Default Valueat

    How to sort the output. The value ofsort_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).

  • -tN

    TypeNumeric

    Display only the firstN queries in the output.

  • --verbose,-v

    Command-Line Format--verbose

    Verbose mode. Print more information about what the program does.