mysql数据库 常用语句-查内存和索引内存

统计mysql 库  数据表  内存  和  索引占用磁盘数

SELECT
	TABLE_NAME,
	concat( TRUNCATE ( data_length / 1024 / 1024, 2 ), ' MB' ) AS data_size,
	concat( TRUNCATE ( index_length / 1024 / 1024, 2 ), ' MB' ) AS index_size 
FROM
	information_schema.TABLES 
WHERE
	TABLE_SCHEMA = 'you_database_name' 
ORDER BY
	data_length DESC;

　

统计mysql 数据  数据表 某张表 数据内存 和  索引占磁盘树

SELECT
	TABLE_NAME,
	concat( TRUNCATE ( data_length / 1024 / 1024, 2 ), ' MB' ) AS data_size,
	concat( TRUNCATE ( index_length / 1024 / 1024, 2 ), ' MB' ) AS index_size 
FROM
	information_schema.TABLES 
WHERE
	TABLE_SCHEMA = 'you_database_name' 
	AND TABLE_NAME = 'table_name';