MySQL查询数据库中的表占用空间的大小
1、查看指定数据库中各表占用空间的大小
1 2 3 4 5 6 7 8 |
select table_schema as '数据库', table_name as '表名', table_rows as '记录数', truncate(data_length/1024/1024, 2) as '数据容量(MB)', truncate(index_length/1024/1024, 2) as '索引容量(MB)' from information_schema.tables where table_schema='数据库名称' order by data_length desc, index_length desc |
2、查看各数据库占用空间的大小
1 2 3 4 5 6 7 |
select table_schema as '数据库', sum(table_rows) as '记录数', sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)', sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)' from information_schema.tables group by table_schema order by sum(data_length) desc, sum(index_length) desc; |
2022年7月22日11:27:55
版权声明:
作者:龙魂
链接:https://blog.wlzs.cn/mysql%e6%9f%a5%e8%af%a2%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%ad%e7%9a%84%e8%a1%a8%e5%8d%a0%e7%94%a8%e7%a9%ba%e9%97%b4%e7%9a%84%e5%a4%a7%e5%b0%8f/
文章版权归作者所有,未经允许请勿转载。
THE END