数据库查询各表占用内存大小

SELECT

table_name,

table_rows ,

TRUNCATE (data_length / 1024 / 1024/ 1024, 2) AS '数据容量(GB)',

TRUNCATE (index_length / 1024 / 1024/ 1024, 2)AS '索引容量(GB)'

FROM

information_schema.TABLES

WHERE

TABLE_SCHEMA = 'isp_produce'

ORDER BY

TRUNCATE (data_length / 1024 / 1024, 2) DESC

LIMIT 10;