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;