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.
Instructs the utility not to combine queries with similar SQL statements.
Enables debugging mode.
Extracts information on queries that meet the given expression.
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.
Specifies the hostname of the server.
With this option, the lock time is added to the execution time for the utility’s summary.
Sets the minimum number of occurrences for reporting.
Reverses the order of sorts for reporting.
Specifies the type of queries on which to report. The choices are
al for average lock time,
for average rows,
at for average execution time,
l for lock time,
r for rows,
t for execution time.
Sets the number of queries on which to display.
Displays more information.