mysqldumpslow
MariaDB starting with 10.4.6
From MariaDB 10.4.6, mariadb-dumpslow is a symlink to mysqldumpslow.
MariaDB starting with 10.5.2
From MariaDB 10.5.2, mariadb-dumpslow is the name of the tool, with mysqldumpslow a symlink .
mysqldumpslow is a tool to examine the slow query log.
It parses the slow query log files, printing a summary result. 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.
Usage
mysqldumpslow [ options... ] [ logs... ]
Options
| Option | Description |
|---|---|
-a |
Don't abstract all numbers to N and strings to 'S' |
-d, --debug
|
Debug |
-g PATTERN |
Grep: only consider statements that include this string |
--help |
Display help |
-h HOSTNAME |
Hostname of db server for *-slow.log filename (can be wildcard), default is '*', i.e. match all |
-i NAME |
Name of server instance (if using mysql.server startup script) |
-l |
Don't subtract lock time from total time |
-n NUM |
Abstract numbers with at least NUM digits within names |
-r |
Reverse the sort order (largest last instead of first) |
-s ORDER |
What to sort by (aa, ae, al, ar, at, a, c, e, l, r, t). at is default. aa average rows affected ae aggregated number of rows examined al average lock time ar average rows sent at average query time a rows affected c count e rows examined l lock time r rows sent t query time |
-t NUM |
Just show the top NUM queries. |
-v, --verbose
|
Verbose mode. |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqldumpslow/