(mysql.info) checksum-table

(mysql.info) table-maintenance-sql

 
 13.5.2.4 `CHECKSUM TABLE' Syntax
 ................................
 
      CHECKSUM TABLE TBL_NAME [, TBL_NAME] ... [ QUICK | EXTENDED ]
 
 `CHECKSUM TABLE' reports a table checksum.
 
 With `QUICK', the live table checksum is reported if it is available,
 or `NULL' otherwise. This is very fast. A live checksum is enabled by
 specifying the `CHECKSUM=1' table option when you create the table;
 currently, this is supported only for `MyISAM' tables. See 
 create-table.
 
 With `EXTENDED', the entire table is read row by row and the checksum
 is calculated. This can be very slow for large tables.
 
 If neither `QUICK' nor `EXTENDED' is specified, MySQL returns a live
 checksum if the table storage engine supports it and scans the table
 otherwise.
 
 For a non-existent table, `CHECKSUM TABLE' returns `NULL' and, as of
 MySQL 5.0.3, generates a warning.

Info Catalog

(mysql.info) check-table

(mysql.info) table-maintenance-sql

(mysql.info) optimize-table

automatically generated byinfo2html