2014
01-09
01-09
mysql mysqlcheck详解 2094 VIEW
mysqlcheck --repair --all-databases -uphpac -pphpac
即可最佳化所有db
参数含意:
-a = Analyse given tables.
-c = Check table for errors
-o = Optimise table
-r = Can fix almost anything except unique keys that aren't unique
-m = --medium-check
mysqlcheck客户端可以检查和修复MyISAM表。它还可以优化和分析表。
mysqlcheck的功能类似.... more...