Check MySQL Database Size

页面导航:首页 > 数据库 > Mysql > Check MySQL Database Size

Check MySQL Database Size

来源: 作者: 时间:2016-02-03 08:56 【

Check MySQL Database [email protected] 11:11:29SELECT - ROUND( - SUM(data_length + index_length) 1024 1024 - ) TOTAL_MB, - ROUND(SUM(
Check MySQL Database Size
 
[email protected] 11:11:29>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)  

[email protected] 11:16:13>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 |  
|               | 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)  


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;


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;

 


Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<