Check MySQL Database Size_MySQL-MySQL-Tutorial-php.cn

Heim

Datenbank

MySQL-Tutorial

Check MySQL Database Size_MySQL

Jun 01, 2016 pm 01:28 PM

bitsCN.com

Check MySQL Database Size

root@zwc 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)  root@zwc 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 |  | 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)  SELECTTABLE_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"FROMinformation_schema. TABLESGROUP BYTABLE_SCHEMA,ENGINEORDER BY 3 DESC;SELECTROUND(SUM(data_length + index_length) / 1024 / 1024) TOTAL_MB,ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,ROUND(SUM(index_length) / 1024 / 1024) INDEX_MBFROMinformation_schema. TABLES;

Nach dem Login kopieren

bitsCN.com

Erklärung dieser Website

Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn