查看Mysql数据库大小

查看数据库的大小，并按照schema分组

select TABLE_SCHEMA,concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') from tables GROUP BY TABLE_SCHEMA;