一个某某库大概360W,
为了提高查询
效率，
做点优化，使用optimizetabletable.name;出现Tabledoesnotsupportoptimize,doingrecreate+analyzeinstead
果断谷歌，查到一段E文。。。
EverytimeyoudooptimizeMySQL,byusingmysqlcheck-A-oorusing./mysql_optimizefromhere.
Youmayseetheoutput
Tabledoesnotsupportoptimize,doingrecreate+analyzeinstead.
ItisbecausethetablethatyouareusingisInnoDB.
YoucanoptimizetheInnoDBtablesbyusingthis.
复制代码