查询MySQL系统表相关

1. 查询指定schema下的各张表的数据大小、索引大小以及行数

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