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.查看指定数据库容量大小
例：查看mysql库容量大小

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.查看指定数据库各表容量大小
例：查看mysql库各表容量大小

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;
来源：https://blog.csdn.net/fdipzone/article/details/80144166 发布时间：2022-02-23 21:08:17
Alt Text

分类

PHP Golang Python Javascript Mysql Linux Nginx PHP IDE工具 vagrant postman Redis Swoole MongoDB 其他 PHP Python HTML Lua 算法 PHP 设计原理 面试题 其他 内存缓存

最新

置顶

热门

精华

标签

Mysql 无聊 开发工具 服务器 实验 源代码 测试工具 软件 linux Golang JS PHP 技术