MySQL資料表碎片查詢

需求：查詢碎片大于100m的表，并自動整理

查詢碎片

SELECT `TABLE_SCHEMA` as 'database_name',`TABLE_NAME` as 'table_name',(`DATA_LENGTH`+`INDEX_LENGTH`)-(`TABLE_ROWS`*`AVG_ROW_LENGTH`) as splinter 
FROM information_schema.`TABLES` 
WHERE `TABLE_TYPE`='BASE TABLE' 
HAVING splinter >104857600;           

optimize table database_name.table_name