- MySQL 5.1 Reference Manual :: 4 MySQL Programs :: 4.6 MySQL Administrative and Utility Programs :: 4.6.3 myisamchk — MyISAM Table-Maintenance Utility :: 4.6.3.2 myisamchk Check Options
-
- MySQL 5.1 Reference Manual
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
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 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 thekey_buffer_size
variable to a large value helps the repair operation run faster.For a description of the output format, see Section 4.6.3.5, “myisamchk Table Information”.
-
--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
Do not 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 does not 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.