Mysql查看数据库表容量大小

1)查看各数据库记录数,容量大小

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

  

 

posted @ 2020-10-28 11:37  楔子  阅读(175)  评论(0)    收藏  举报