Mysql数据库各表统计

use information_schema;
SELECT 
   TABLE_NAME,
	(DATA_LENGTH/1024/1024) as DataM ,
	(INDEX_LENGTH/1024/1024) as IndexM, 
	((DATA_LENGTH+INDEX_LENGTH)/1024/1024) as AllM,
	TABLE_ROWS
FROM
    TABLES
WHERE
    TABLE_SCHEMA = 'ceilometer';