mysql查询表的数据量、磁盘空间

数据量

SELECT * from information_schema.TABLES where table_name=‘user’;

磁盘空间，单位G

SELECT DATA_LENGTH/(1024*1024*1024),INDEX_LENGTH/(1024*1024*1024) from information_schema.TABLES where table_name='user' and TABLE_SCHEMA=‘database_name';

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

| DATA_LENGTH/(1024*1024*1024) | INDEX_LENGTH/(1024*1024*1024) |

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

|                      48.6056 |                       77.8659 |

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

1 row in set (0.02 sec)