mysql修复工具mysqlcheck 和myisamchk的区别

0 条评论

mysqlcheck -a -c -o -r -m --all-databases -uroot -p
注:MYSQL版本为5.5时,命令中请删除-o
即可最佳化所有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