select table_name,table_rows,data_length+index_length, concat(round((data_length+index_length)/1024/1024,2),'MB') data from tables where table_schema='xxx_db';
查看某个数据库的各个表的大小
最新推荐文章于 2023-08-24 11:14:04 发布
select table_name,table_rows,data_length+index_length, concat(round((data_length+index_length)/1024/1024,2),'MB') data from tables where table_schema='xxx_db';