-- 查询单个数据库里面各个表所占磁盘空间大小包括其索引的大小,SQL语句如下:
select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,10), 'MB') as data_size, concat(truncate(sum(data_length), 0), 'B'),
concat(truncate(sum(index_length)/1024/1024,2), 'MB') as index_size
from information_schema.tables where TABLE_SCHEMA = '7g_hz_sw'
group by TABLE_SCHEMA;
-- mysql 查看数据库中所有表的记录数
select table_name,table_rows from tables
where TABLE_SCHEMA = '7g_hz_sw'
order by table_rows desc;
mysql查询数据库和每个表所占空间大小
最新推荐文章于 2024-07-23 13:22:23 发布