前言：
现时咱们对“mysql显示表大小”可能比较关注，同学们都想要剖析一些“mysql显示表大小”的相关文章。那么小编同时在网络上收集了一些关于“mysql显示表大小””的相关资讯，希望你们能喜欢，各位老铁们一起来了解一下吧！概述
今天主要介绍MySQL查看数据库表容量大小的几个方法，仅供参考。
1、查看所有数据库容量大小
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;2、查看所有数据库各表容量大小
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 ORDER BY data_length DESC, index_length DESC;3、查看指定数据库容量大小
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 WHERE table_schema = 'mysql';4、查看指定数据库各表容量大小
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 = 'mysql' ORDER BY data_length DESC, index_length DESC;
后面会分享更多devops和DBA方面的内容，感兴趣的朋友可以关注下！
版权声明：
本站文章均来自互联网搜集，如有侵犯您的权益，请联系我们删除，谢谢。
标签： #mysql显示表大小
