SELECT table_schema, concat( TRUNCATE ( sum(data_length) / 1024 / 1024, 2 ), ' mb' ) AS data_size, concat( TRUNCATE ( sum(index_length) / 1024 / 1024, 2 ), 'mb' ) AS index_size FROM information_schema. TABLES
#where table_schema = 'youdb' GROUP BY table_schema ORDER BY data_length DESC;