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'