SELECT `TABLE_SCHEMA`, SUM(`DATA_LENGTH`)/1024/1024, SUM(`INDEX_LENGTH`)/1024/1024, SUM(`DATA_LENGTH`+`INDEX_LENGTH`)/1024/1024 FROM `information_schema`.`TABLES` GROUP BY `TABLE_SCHEMA`
单位:MB
SELECT `TABLE_SCHEMA`, SUM(`DATA_LENGTH`)/1024/1024, SUM(`INDEX_LENGTH`)/1024/1024, SUM(`DATA_LENGTH`+`INDEX_LENGTH`)/1024/1024 FROM `information_schema`.`TABLES` GROUP BY `TABLE_SCHEMA`
单位:MB
转载于:https://my.oschina.net/yestreenstars/blog/1634371