mysql> SELECT table_schema,table_name,data_length,index_length -> FROM information_schema.tables ORDER BY data_length DESC LIMIT 5; +----------------+-----------------------+-------------+--------------+ | table_schema | table_name | data_length | index_length | +----------------+-----------------------+-------------+--------------+ | communit_pablo | twitter_statuses | 18455986176 | 7163789312 | | communit_pablo | twitter_relationships | 15031681024 | 24680136704 | | communit_pablo | members | 14825160704 | 18110201856 | | communit_pablo | twitter_identities | 10196353024 | 4559503360 | | communit_pablo | members_new1 | 9934143488 | 12745244672 | +----------------+-----------------------+-------------+--------------+ 5 rows in set, 1 warning (29 min 38.94 sec)