查看数据库表格大小-优快云博客

博客展示了数据库查询操作，通过SQL语句从information_schema.TABLES中查询指定数据库'hx'的表名、数据与索引长度总和以及表行数，还对特定表'enjoy_data'进行了相关查询。

SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='hx';

+-------------------+--------------------------+------------+
| TABLE_NAME        | DATA_LENGTH+INDEX_LENGTH | TABLE_ROWS |
+-------------------+--------------------------+------------+
| enjoy_data    |                  6979584 |      70113 |
| hx_record      |                113410048 |     753279 |
| itlearner_record       |              21835546624 | 104917777 |
| tmp_day_id        |                    17326 |        811 |
+-------------------+--------------------------+------------+

SELECT DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='hx' AND TABLE_NAME = 'enjoy_data';

+--------------------------+------------+
| DATA_LENGTH+INDEX_LENGTH | TABLE_ROWS |
+--------------------------+------------+
| 6979584 | 70113 |
+--------------------------+------------+

转载于:https://www.cnblogs.com/pansidong/p/9562025.html