MyISAM table maintenance can be done using SQL statements.
MyISAM tables, use CHECK TABLE or REPAIR TABLE.
MyISAM tables, use OPTIMIZE TABLE.
MyISAM tables, use ANALYZE TABLE.
myisamchk utility gets information about database tables or checks, repairs, or optimizes them.
myisamchk works with MyISAM tables.
.MYD and .MYI files for storing data and indexes.
myisamchk like this:
myisamchk [options] tbl_namemyisamchk with no options simply checks the table.
myisamchk --help
myisamchk to repair or optimize tables, always ensure the mysqld server is not using the table.
myisamchk access the tables simultaneously.
mysqld
mysqladmin flush-tables before running myisamchk.
How does myisamchk work?
© 2007 John Michael Pierobon