content_image/686463.jpg
<img src='content_image/686463.jpg'>

• --help 

Display a help message and exit. 

• -a 

Do not abstract all numbers to N  and strings to ’S’ . 

• --debug , -d 

Run in debug mode. 

This option is available only if MySQL was built using WITH_DEBUG . MySQL release binaries provided by Oracle are not  built using this option. 

• -g pattern 

Consider only queries that match the ( grep -style) pattern. 

• -h host_name 

Host name of MySQL server for *-slow.log  file name. The value can contain a wildcard. The default is *  (match all). 

• -i name 

Name of server instance (if using mysql.server  startup script). 

• -l 

Do not subtract lock time from total time. 

• -n N 

Abstract numbers with at least N  digits within names. 

• -r 

Reverse the sort order. 

• -s sort_type 

How to sort the output. The value of sort_type  should be chosen from the following list: 

• 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 

By default, mysqldumpslow  sorts by average query time (equivalent to -s at ). 

• -t N 

