mysql 查看数据量

#以mb单位显示dbname的数据量
select concat(round(sum(DATA_LENGTH/1024/1024),2), 'MB') as data from information_schema.TABLES where information_schema.TABLES.TABLE_SCHEMA='dbname';