本文提供了一系列SQL查询语句，用于获取数据库及其特定表的数据大小。这些查询可以帮助管理员了解不同数据库及表所占用的空间，并据此进行资源管理和优化。
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables;
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='fungame';
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='fungame' and table_name='user_info';
select table_schema,concat(round(sum(data_length/1024/1024),2),'MB') as data from tables group by table_schema;
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='fungame';
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='fungame' and table_name='user_info';
select table_schema,concat(round(sum(data_length/1024/1024),2),'MB') as data from tables group by table_schema;
扫一扫
611
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
