W3cubDocs

/MariaDB

mysqldumpslow

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.

From MariaDB 10.4.6, mariadb-dumpslow is a symlink to mysqldumpslow.

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqldumpslow/