MySQL查询数据库、表所占空间

1.查询数据库所占空间

SELECT Concat( Round((sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024,2),'MB') as datas
FROM information_schema.TABLES where TABLE_SCHEMA='map';

2.查询数据库里面各个表所占空间

SELECT table_name, data_length + index_length AS len, table_rows,
 
     CONCAT(ROUND((data_length + index_length)/1024/1024,2),'MB') AS datas
 
FROM information_schema.tables
 
WHERE table_schema = 'map'