Check Mysql Database Size

最新推荐文章于 2024-05-17 01:22:20 发布

转载最新推荐文章于 2024-05-17 01:22:20 发布 · 746 阅读

PHP 同时被 3 个专栏收录

102 篇文章

订阅专栏

linux

100 篇文章

订阅专栏

SQL SERVER / Mysql

25 篇文章

订阅专栏

本文详细解析了数据库中表的总容量、数据容量和索引容量，并按存储引擎进行了分类，提供了各存储引擎下的主要表容量信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT ROUND(  SUM(data_length + index_length) / 1024 / 1024  ) TOTAL_MB,  ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,  ROUND(  SUM(index_length) / 1024 /1024  ) INDEX_MB  FROM information_schema.TABLES;

+----------+---------+----------+ 

|
 TOTAL_MB | DATA_MB | INDEX_MB |  

+----------+---------+----------+ 

|     
 944 |     466 |      478 |  

+----------+---------+----------+ 

1
 row in

set 
(0.04 sec)  

SELECT 
     TABLE_SCHEMA,  
     ENGINE,  
     ROUND(  
     SUM(data_length + index_length) / 1024 / 1024  
     ) TOTAL_MB,  
     ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,  
     ROUND(  
     SUM(index_length) / 1024 / 1024  
     ) INDEX_MB,  
     count(*) "TABLES" 
     FROM 
     information_schema. TABLES  
     GROUP BY 
     TABLE_SCHEMA,  
     ENGINE  
     ORDER BY 3 DESC;

+--------------------+--------------------+----------+---------+----------+--------+ 

|
 TABLE_SCHEMA       | ENGINE             | TOTAL_MB | DATA_MB | INDEX_MB | TABLES | 

+--------------------+--------------------+----------+---------+----------+--------+ 

|
 zwc                | MyISAM             |      485 |     191 |      294 |      1 | 

|
 zwc                | InnoDB             |      456 |     273 |      183 |      1 | 

|
 common_schema      | InnoDB             |        2 |       2 |        0 |     11 | 

|
 mysql              | MyISAM             |        1 |       1 |        0 |     22 | 

|
 information_schema | MyISAM             |        0 |       0 |        0 |      9 | 

|
 mysql              | CSV                |        0 |       0 |        0 |      2 | 

|
 information_schema | MEMORY             |        0 |       0 |        0 |     28 | 

|
 common_schema      | MyISAM             |        0 |       0 |        0 |      7 | 

|
 performance_schema | PERFORMANCE_SCHEMA |        0 |       0 |        0 |     17 | 

|
 common_schema      | NULL              

|     NULL

|    NULL

|     NULL

|     62 |  

+--------------------+--------------------+----------+---------+----------+--------+ 

10
rows

in 
set 
(0.03 sec)  

Check table number:

SELECT
TABLE_SCHEMA,
ENGINE,
ROUND(
SUM(data_length + index_length) / 1024 / 1024
) TOTAL_MB,
ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,
ROUND(
SUM(index_length) / 1024 / 1024
) INDEX_MB,
count(*) "TABLES"
FROM
information_schema. TABLES
GROUP BY
TABLE_SCHEMA,
ENGINE
ORDER BY 3 DESC;