526互联

查询mysql的数据库容量

发布时间 2023-04-07 17:43:18作者: 悄悄的来，匆匆的走

查看所有数据库容量大小

SELECT
	table_schema AS '数据库',
	sum( table_rows ) AS '记录数',
	sum(
	TRUNCATE ( data_length / 1024 / 1024/1024, 2 )) AS '数据容量(G)',
	sum(
	TRUNCATE ( index_length / 1024 / 1024/1024, 2 )) AS '索引容量(G)' 
FROM
	information_schema.TABLES 
GROUP BY
	table_schema 
ORDER BY
	sum( data_length ) DESC,
	sum( index_length ) DESC;

　　

查看所有数据库各表容量大小

	SELECT
	table_schema AS '数据库',
	table_name AS '表名',
	table_rows AS '记录数',
	TRUNCATE ( data_length / 1024 / 1024/1024, 2 ) AS '数据容量(G)',
	TRUNCATE ( index_length / 1024 / 1024/1024, 2 ) AS '索引容量(G)' 
FROM
	information_schema.TABLES 
ORDER BY
	data_length DESC,
	index_length DESC;