mariadb-dumpslow
Summarize and analyze the MariaDB slow query log with mariadb-dumpslow (formerly mysqldumpslow), grouping similar queries to surface the slowest statements.
mariadb-dumpslow is a tool to examine the slow query log.
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
-a
Don't abstract all numbers to N and strings to 'S'.
-d, --debug
Debug mode.
-g`` pattern
Grep: only consider statements that include this string pattern.
--help
Display help.
-h`` hostname
Hostname of db server for -slow.log filename (can be a wildcard). The Default is '', that is, match all hosts.
-i`` name
Name of server instance (if using mysql.server startup script).
-l
Don't subtract lock time from total time.
-j, --json
Stores the dumped data in JSON format. Available from MariaDB 12.1.
-n`` number
Abstract numbers with at least this number of 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). The default is at . The meaning of the abbreviations is:
aa– average rows affectedae– aggregated number of rows examinedal– average lock timear– average rows sentat– average query timea– rows affectedc– counte– rows examinedl– lock timer– rows sentt– query time:
-t`` number
Just show the top number of queries.
-v, --verbose
Verbose mode.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

