Contents

  1. Usage
  2. Options

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

OptionDescription
-aDon't abstract all numbers to N and strings to 'S'
-d, --debugDebug
-g PATTERNGrep: only consider statements that include this string
--helpDisplay help
-h HOSTNAMEHostname of db server for *-slow.log filename (can be wildcard), default is '*', i.e. match all
-i NAMEName of server instance (if using mysql.server startup script)
-lDon't subtract lock time from total time
-n NUMAbstract numbers with at least NUM digits within names
-rReverse the sort order (largest last instead of first)
-s ORDERWhat to sort by (al, at, ar, ae, c, l, r, e, t) at is default. al average lock time. ar average rows sent, at average query time, c count, l lock time, r rows sent, t query time.
-t NUMJust show the top NUM queries.
-v, --verboseVerbose mode.

Comments

Comments loading...