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.
-aDon't abstract all numbers to N and strings to 'S'.
-d, --debugDebug mode.
-g patternGrep: only consider statements that include this string pattern.
--helpDisplay help.
-h hostnameHostname of db server for -slow.log filename (can be a wildcard). The Default is '', that is, match all hosts.
-i nameName of server instance (if using mysql.server startup script).
-lDon't subtract lock time from total time.
-j, --jsonStores the dumped data in JSON format. Available from MariaDB 12.1.
-n numberAbstract numbers with at least this number of digits within names.
-rReverse the sort order (largest last instead of first).
-s orderWhat 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 affected
ae – aggregated number of rows examined
al – average lock time
-t numberJust show the top number of queries.
-v, --verboseVerbose mode.
This page is licensed: CC BY-SA / Gnu FDL
ar – average rows sentat – average query time
a – rows affected
c – count
e – rows examined
l – lock time
r – rows sent
t – query time:
mariadb-dumpslow [ options... ] [ logs... ]