CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE - Mysql

Hi...

mysqlcheck command is used for check the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user. It determines which statements to use for the operation you want to perform, and then sends the statements to the server to be executed.

To check the tables for errors use the below command


To optimize the tables use the below command

To perform a repair that can fix almost anything except unique keys that are not unique. use the below command


To analyse the table use the below command


test -> databasename