Table Maintenance Statements – MySQL Tutorials

In this section we are covering the topics like ANALYZE TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE TABLE Syntax.
ANALYZE TABLE Syntax
The general syntax of ANALYZE TABLE statement is:
        ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] …
This syntax is used to analyze and store the key distribution to a table. [...]