CHECK TABLE

CHECK TABLE tbl_name[,tbl_name...] [option [option...]]

The option can be one of the following:

CHANGED EXTENDED FAST MEDIUM QUICK

This checks a MyISAM or InnoDB table for errors and, for MyISAM tables, updates the index statistics. The QUICK option doesn't scan the rows to check links. The FAST option only checks tables that weren't closed properly. The CHANGED option is the same as FAST, except that it also checks tables that have changed since the last check. The MEDIUM option verifies that deleted links are correct, and the EXTENDED option does a full index lookup for each key in each row.



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net