java计算mysql索引长度_查看mysql数据库 数据量大小和索引数据大小

查看某个数据库的数据量 和索引量的大小

SELECT

SUM(DATA_LENGTH)/ 1024 / 1024 + SUM(INDEX_LENGTH)/ 1024 / 1024

FROM

information_schema. TABLES

WHERE

TABLE_SCHEMA = 'ice_produce_cn';

查看索引量的大小

SELECT

SUM(INDEX_LENGTH)/ 1024 / 1024

FROM

information_schema. TABLES

WHERE

TABLE_SCHEMA = 'ice_produce_cn';

查看数据量排名前100的表

select TABLE_NAME,DATA_LENGTH/ 1024 / 1024,TABLE_ROWS,ENGINE from information_schema.TABLES

WHERE TABLE_SCHEMA = 'ice_produce_cn' order by DATA_LENGTH desc limit 100;

查看索引数据排名前100的表

SELECT

TABLE_NAME,

(DATA_LENGTH / 1024 / 1024) ,

(INDEX_LENGTH / 1024 / 1024) ,

TABLE_ROWS,

ENGINE

FROM

information_schema.TABLES

WHERE

TABLE_SCHEMA = 'ice_produce_cn'

ORDER BY

DATA_LENGTH DESC,

INDEX_LENGTH DESC

LIMIT 100;