mysqldumpslow — Summarize Slow Query Log Files Option Name Description --verbose Verbose mode • --help • -a • --debug ,  -d • -g  pattern • -h  host_name • -i  name • -l • -n  N • -r • -s  sort_type • -t  N • t ,  at : Sort by query time or average query time • l ,  al : Sort by lock time or average lock time • r ,  ar : Sort by rows sent or average rows sent • c : Sort by count How to sort the output. The value of  sort_type  should be chosen from the following list: Reverse the sort order. Do not subtract lock time from total time. Abstract numbers with at least  N  digits within names. Name of server instance (if using  mysql.server  startup script). Host name of MySQL server for  *-slow.log  file name. The value can contain a wildcard. The default is *  (match all). This option is available only if MySQL was built using  WITH_DEBUG . MySQL release binaries provided by Oracle are  not  built using this option. Consider only queries that match the ( grep -style) pattern. Run in debug mode. Do not abstract all numbers to  N  and strings to  ’S’ . Display a help message and exit. By default,  mysqldumpslow  sorts by average query time (equivalent to  -s at ). 626