Mysql怎样查看数据库大小

这篇文章给大家介绍关系型数据库怎样查看数据库大小，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

一命令行进入数据库

[root@80~]#mysql-uroot-p

企业词汇：2查看数据库

mysqlshowdatabases

–

数据库|

–

|信息_架构|

|mysql|

|测试|

– 3 查看信息模式的”表格”

mysqluseinformation _ schema

|TABLES|4查看字段结构

mysqldesctables

– – – – – –

|字段|类型|空|键|默认|额外|

– – – – – –

| TABLE _ CATALOG | varchar(512)| NO | | | |

| TABLE _ SCHEMA | varchar(64)| NO | | | |

| TABLE _ NAME | varchar(64)| NO | | | nb

sp;  |
| TABLE_TYPE      | varchar(64)         | NO   |     |         |       |
| ENGINE          | varchar(64)         | YES  |     | NULL    |       |
| VERSION         | bigint(21) unsigned | YES  |     | NULL    |       |
| ROW_FORMAT      | varchar(10)         | YES  |     | NULL    |       |
| TABLE_ROWS      | bigint(21) unsigned | YES  |     | NULL    |       |
| AVG_ROW_LENGTH  | bigint(21) unsigned | YES  |     | NULL    |       |
| DATA_LENGTH     | bigint(21) unsigned | YES  |     | NULL    |       |
| MAX_DATA_LENGTH | bigint(21) unsigned | YES  |     | NULL    |       |
| INDEX_LENGTH    | bigint(21) unsigned | YES  |     | NULL    |       |
| DATA_FREE       | bigint(21) unsigned | YES  |     | NULL    |       |
| AUTO_INCREMENT  | bigint(21) unsigned | YES  |     | NULL    |       |
| CREATE_TIME     | datetime            | YES  |     | NULL    |       |
| UPDATE_TIME     | datetime            | YES  |     | NULL    |       |
| CHECK_TIME      | datetime            | YES  |     | NULL    |       |
| TABLE_COLLATION | varchar(32)         | YES  |     | NULL    |       |
| CHECKSUM        | bigint(21) unsigned | YES  |     | NULL    |       |
| CREATE_OPTIONS  | varchar(255)        | YES  |     | NULL    |       |
| TABLE_COMMENT   | varchar(2048)       | NO   |     |         |       |
+—————–+———————+——+—–+———+——-+

5 查看DB的数据大小

mysql> select table_schema,round(sum(DATA_LENGTH)/1024/1024,2) as table_size from tables group by table_schema;
+--------------------+------------+
| table_schema       | table_size |
+--------------------+------------+
| bomo_backend       |       0.09 |
| test1              |     234.16 |
| test2              |       0.17 |
| information_schema |       0.00 |
| mysql              |       0.71 |
| performance_schema |       0.00 |
| test               |       0.03 |
+--------------------+------------+

6 查看table的数据大小

mysql> select table_schema,table_name,concat(round(data_length/1024/1024,2),'M') as table_size from tables where table_schema = 'grab';
+--------------+--------------+------------+
| table_schema | table_name   | table_size |
+--------------+--------------+------------+
| grab         | product      | 215.12M    |
| grab         | result       | 13.52M     |
| grab         | rule         | 0.02M      |
| grab         | task         | 5.52M      |
+--------------+--------------+------------+

关于Mysql怎样查看数据库大小就分享到这里了，希望