MySQL in a Nutshell, 2nd Edition

Name

myisamlog

Synopsis

myisamlog options [filename [table ...]]

This utility scans and extracts information from the myisam.log file, which logs debugging messages for the MyISAM table handler. The name of the log file may be given. Also, the command can list specific tables to limit scanning to these tables. To activate the log, add the following line to the MySQL server configuration file (e.g., my.cnf) under the [server] section or the [mysqld] section:

log-isam=/data/mysql/logs/myisam.log

Here is a list of options available for this utility in alphabetical order:

-?, -I

This option displays basic help information.

-c number

This option limits the output to number commands.

-D

Use this option with a server that was compiled with debugging in effect.

-F path

This option provides the file path to use. The path should end with a trailing slash.

-f files

This option sets the maximum number of open files allowed.

-i

This option displays additional information.

-o offset

This option specifies where in the log to begin the scan.

-P

This option displays information about processes.

-p number

This option removes the given number of components from the front of the path.

-R

This option displays the current record position.

-r

This option displays recovery activities.

-u

This option displays update activities.

-V

This option displays the version of the utility.

-v

This option displays more information. Additional vs (e.g., -vv) will increase the amount of information.

-w

This option displays file write activities.