查看碎片
use information_schema;
select
TABLE_SCHEMA,TABLE_NAME,data_free,engine
from
tables
where
engine
in
(
'myisam'
,
'innodb'
) data_free>0;
1、myisam存储引擎清理碎片方法
OPTIMIZE
TABLE
table_name
2、innodb存储引擎清理碎片方法
ALTER
TABLE
tablename ENGINE=InnoDB