MySQL How to optimize the repair database table

　　Recent customer problems said that the site because the database error cannot open, oneself summed up some experience, and then read the wrong information as follows :

　　　

　　　　MySQL database as a good open source database version, support large data storage. However, if too many operations are used, the frequent operation of the table may cause problems with the database tables that need to be optimized and repaired

　　　　　Fix Table-" method one:

In the browser, hit phpMyAdmin or run the following command on the MySQL client:

1) Directly run SQL statements REPAIR table ' table_name ' repair tables, as follows:

　　　　　　　　　　

　　　　　　　　　　　　

　　　　　　　　　2) find operations in the database can also repair the table, specific operations such as:

　　　　　　　　　　　

　　　　　　　　Fix Table --" method two:

You can clear the current database directly, restore the previously backed up user information, this method is slower, of course, it is not recommended to use this method, if you have previously backed up user information.

If it is only a single repair, it will not be long after the table is damaged, at this time, it is recommended to optimize your table, I simply summed up the way to optimize the table, here is just a simple method oh, but practical, specific methods are as follows:

Optimization Table--"Method one:

　　　　　　　　　　In the browser, hit phpMyAdmin or run the following command on the MySQL client:

1) Directly run SQL statements OPTIMIZE table ' table_name ' repair tables, as follows:

　　　　　　　　　　　　　　　　

MySQL How to optimize the repair database table