mysql 使用命令查看数据库大小

mysql> select table_name, concat(round((data_length + index_length +data_free)/1024/1024,2),'MB')from information_schema.tables where table_schema = 'test01'; /*查询单独数据库数据大小*/ ;
+------------+-------------------------------------------------------------------------+
| table_name | concat(round((data_length + index_length +data_free)/1024/1024,2),'MB') |
+------------+-------------------------------------------------------------------------+
| aa | 0.02MB |
| addr | 12.52MB |
| name | 10.52MB |
+------------+-------------------------------------------------------------------------+
3 rows in set

Query OK, 0 rows affected

mysql> select table_name, concat(round((data_length + index_length +data_free)/1024/1024,2),'MB')from information_schema.tables where table_schema = 'test01'and table_name = 'name'; /*查询单独表数据大小*/ ；
+------------+-------------------------------------------------------------------------+
| table_name | concat(round((data_length + index_length +data_free)/1024/1024,2),'MB') |
+------------+-------------------------------------------------------------------------+
| name | 10.52MB |
+------------+-------------------------------------------------------------------------+

查看所有数据大小

mysql> use information_schema;
Database changed
mysql> select table_name, concat(round(sum((data_length + index_length +data_free)/1024/1024),2),'MB') as data from tables;
+----------------+----------+
| table_name | data |
+----------------+----------+
| CHARACTER_SETS | 113.06MB |
+----------------+----------+
1 row in set

 

data_length 数据长度
index_length 索引长度
data_free 碎片长度