查看数据库的大小,并按照schema分组
select TABLE_SCHEMA,concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') from tables GROUP BY TABLE_SCHEMA;
查看数据库的大小,并按照schema分组
select TABLE_SCHEMA,concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') from tables GROUP BY TABLE_SCHEMA;