(mysql.info) myisamchk-check-options
Info Catalog
(mysql.info) myisamchk-general-options
(mysql.info) myisamchk
(mysql.info) myisamchk-repair-options
8.2.2 `myisamchk' Check Options
-------------------------------
`myisamchk' supports the following options for table checking
operations:
* -check, -c
Check the table for errors. This is the default operation if you
specify no option that selects an operation type explicitly.
* -check-only-changed, -C
Check only tables that have changed since the last check.
* -extend-check, -e
Check the table very thoroughly. This is quite slow if the table
has many indexes. This option should only be used in extreme
cases. Normally, `myisamchk' or `myisamchk --medium-check' should
be able to determine whether there are any errors in the table.
If you are using -extend-check and have plenty of memory, setting
the `key_buffer_size' variable to a large value helps the repair
operation run faster.
* -fast, -F
Check only tables that haven't been closed properly.
* -force, -f
Do a repair operation automatically if `myisamchk' finds any
errors in the table. The repair type is the same as that specified
with the -recover or -r option.
* -information, -i
Print informational statistics about the table that is checked.
* -medium-check, -m
Do a check that is faster than an -extend-check operation. This
finds only 99.99% of all errors, which should be good enough in
most cases.
* -read-only, -T
Don't mark the table as checked. This is useful if you use
`myisamchk' to check a table that is in use by some other
application that doesn't use locking, such as `mysqld' when run
with external locking disabled.
* -update-state, -U
Store information in the `.MYI' file to indicate when the table
was checked and whether the table crashed. This should be used to
get full benefit of the -check-only-changed option, but you
shouldn't use this option if the `mysqld' server is using the
table and you are running it with external locking disabled.
Info Catalog
(mysql.info) myisamchk-general-options
(mysql.info) myisamchk
(mysql.info) myisamchk-repair-options
automatically generated byinfo2html