Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement