查看表所占空间大小
SELECT CONCAT(ROUND(SUM(data_length/1024/1024),2),'MB') AS data_length_MB,
CONCAT(ROUND(SUM(index_length/1024/1024),2),'MB') AS index_length_MB,TABLE_NAME
FROM TABLES WHERE table_schema='db_name'
GROUP BY TABLE_NAME
www.kaixinlc.com