mariadb-dumpslow
mariadb-dumpslow
is a tool to examine the slow query log.
Prior to MariaDB 10.5, the client was called mysqldumpslow
. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.
It parses the slow query log files, printing a summary result. Normally, mariadb-dumpslow 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
mariadb-dumpslow [ 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.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?