This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: ran5000 on Jul 10th, 2012  |  syntax: MySQL  |  size: 0.82 KB  |  views: 18  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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)
clone this paste RAW Paste Data