O'Reilly logo

MySQL in a Nutshell by Russell J.T. Dyer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

myisamlog

Synopsis

myisamlog options [filename [table  . . . ]]

Use this to scan and extract information from the myisam.log file, which logs debugging messages for the MyISAM table handler. The path and name of the logfile 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

This utility has several options for retrieving data from the log. Here is a list of them along with a brief explanation of each:

-?, -I

Displays basic help information.

-c number

Limits the output to number commands.

-D

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

-F path

Provides the file path to use. The path should end with a trailing slash.

-f files

Sets the maximum number of open files allowed.

-o offset

Specifies where in the log to begin the scan.

-P

Displays information about processes.

-p number

Instructs the utility to remove the given number of components from the path.

-R

Displays the current record position.

-r

Displays recovery activities.

-u

Displays update activities.

-V

Displays the version of the utility.

-v

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

-w

Displays file write activities.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required