【MYSQL计算表记录占空间大小】

1、

SELECT table_name, table_rows, data_length + index_length, CONCAT( ROUND( (data_length + index_length) / 1024 / 1024, 2 ), 'MB' ) DATA FROM information_schema.tables WHERE table_schema = 'test_schema' ORDER BY DATA DESC;

SELECT (SUM(DATA_LENGTH) + SUM(INDEX_LENGTH))/1024/1024 FROM information_schema.tables WHERE table_schema = 'test_schema';