mysqldumpslow


mysqldumpslow

mysqldumpslow [options] [filename]

Use this to display a summary of the slow query log. The path and name of the logfile may be given in the second argument. Otherwise, the utility will look to the server's configuration file (i.e., my.cnf) for this information. The following options can narrow the summary or change what is displayed.


-a

Instructs the utility not to combine queries with similar SQL statements.


-d

Enables debugging mode.


-g expression

Extracts information on queries that meet the given expression.


-h host

Specifies the host's name for which the utility is to scan. By default, logfiles are named with the server's hostname as the filename's prefix.


-i host

Specifies the hostname of the server.


-l

With this option, the lock time is added to the execution time for the utility's summary.


-n number

Sets the minimum number of occurrences for reporting.


-r

Reverses the order of sorts for reporting.


-s type

Specifies the type of queries on which to report. The choices are al for average lock time, ar for average rows, at for average execution time, l for lock time, r for rows, and t for execution time.


-t

Sets the number of queries on which to display.


-v

Displays more information.



MySQL in a Nutshell
MYSQL in a Nutshell (In a Nutshell (OReilly))
ISBN: 0596514336
EAN: 2147483647
Year: 2006
Pages: 134
Authors: Russell Dyer

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net