Name
myisamlog
Synopsis
myisamlogoptions
[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
v
s (e.g.,-vv
) will increase the amount of information.-
-w
Displays file write activities.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.