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)