SHARE
TWEET

Untitled

ran5000 Jul 10th, 2012 20 Never
  1. mysql> SELECT table_schema,table_name,data_length,index_length
  2.     -> FROM information_schema.tables ORDER BY data_length DESC LIMIT 5;
  3.  
  4. +----------------+-----------------------+-------------+--------------+
  5. | table_schema   | table_name            | data_length | index_length |
  6. +----------------+-----------------------+-------------+--------------+
  7. | communit_pablo | twitter_statuses      | 18455986176 |   7163789312 |
  8. | communit_pablo | twitter_relationships | 15031681024 |  24680136704 |
  9. | communit_pablo | members               | 14825160704 |  18110201856 |
  10. | communit_pablo | twitter_identities    | 10196353024 |   4559503360 |
  11. | communit_pablo | members_new1          |  9934143488 |  12745244672 |
  12. +----------------+-----------------------+-------------+--------------+
  13. 5 rows in set, 1 warning (29 min 38.94 sec)
RAW Paste Data
Top