mysql 查看数据库下，库数据大小和库索引大小

 

 

1. 查看数据库下，库数据大小和库索引大小

SELECT
	TABLE_SCHEMA '库名',
	concat(TRUNCATE (sum(data_length) / 1024 / 1024,2),' MB')  '库大小',
	concat(TRUNCATE (sum(index_length) / 1024 / 1024,2),'MB')  '索引大小'
FROM
	information_schema. TABLES
/*
WHERE
	table_schema = 'beyond'
AND table_name = 't_user_base';
*/
GROUP BY
	TABLE_SCHEMA
ORDER BY
	data_length DESC;

 

 

 

2. 查看 beyond 数据库下，数据大小和索引大小 

SELECT
	TABLE_NAME,
	concat(truncate(data_length/1024/1024,2),' MB') '库大小',
	concat(truncate(index_length/1024/1024,2),' MB')  '索引大小'
FROM
	information_schema. TABLES
WHERE
	TABLE_SCHEMA = 'beyond'
GROUP BY
	TABLE_NAME
ORDER BY
	data_length DESC;

 

3. 索引建的有严重问题