|
|
CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE - Mysql - Linux
|
Views : 887
|
|
Tagged in : Linux
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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
#mysqlcheck -c test
To optimize the tables use the below command
#mysqlcheck -o test
To perform a repair that can fix almost anything except unique keys that are not unique. use the below command
#mysqlcheck -r test
To analyse the table use the below command
#mysqlcheck -a test
test -> databasename |
|
By Nirmala, On - 2009-03-03 |
|
|
|
