查看mysql库中所有表的大小和记录数（排序）

---

-- 查看mysql库中所有表的大小和记录数（排序）
SELECT 
	TABLE_NAME, DATA_LENGTH, INDEX_LENGTH,
	( DATA_LENGTH + INDEX_LENGTH ) AS length, TABLE_ROWS, 
	concat( round(( DATA_LENGTH + INDEX_LENGTH )/ 1024 / 1024, 3 ), 'MB') AS total_size,
	TABLE_COMMENT 
FROM
	information_schema.TABLES 
WHERE
	TABLE_SCHEMA = 'datagateway_std' 
ORDER BY
	length DESC;

如下图：

---