Optimize,Check,Repair,Table

OPTIMIZING, CHECKING, REPAIRING, ANALYZING TABLE

Optimize Table

***SYNTAX***
OPTIMIZE TABLE [tablename];

[To a pc, it needs defragmentation inorder for the memory spaces will compress, in mysql optimizing is an effective way of defragmenting the table. By the use of optimize table the allotted memory spaces for those table that have been deleted and the spaces of the existing tables will compress ]

Check Table 

***SYNTAX***
CHECK TABLE [tablename];

[check table is used for checking errors in the table. These errors might occur because of the storage format for a data type has changed, or the order has changed]

Repair Table

***SYNTAX***
REPAIR TABLE [tablename];

[This will help or used in repairing those corrupted table. This will help repair those particular table that has been corrupted so that is can use well and properly.]

Analyze Table

***SYNTAX***

ANAYZE TABLE [tablename];

[By analyzing the table will help to decide what should be a specific index to use or not use. We need to analyze tables because of lot of modification of a table, the optimizer might not chose the best index to be used. By this updated index information will be generated and will improve the performance]

www.mysql.com - source of information