MySQL database optimization, recovery and other operations

1, when your self-increment ID primary key is large, you want to let the ID back to 1 starting from the increment please enter: truncatetable name;

2, when your database corruption, you don't panic first try this command can help you please enter: Repair table 1, table 2 ...

3, when your data table contains varchar, text, etc., and to delete the addition of multiple operations,

Will generate a lot of debris space, this time wasted resources, need to do data table optimization,

then you can regain the debris space, enter: Optimize table table 1, table 2 ...

Note:  OPTIMIZE Table works only on MyISAM, BDB, and InnoDB tables. Also, MySQL locks the table during the Optimize table run.