MySQL: 统计索引碎片

统计排名前十个索引碎片

select
  table_schema AS db,
  table_name,
      data_free ,
  engine
from
  information_schema.tables
where
  table_schema not in ('information_schema', 'mysql')
  and data_free > 0 order by data_free desc
LIMIT
  10;