Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TABLE_NAME, table_rows, data_length, index_length,
- round(((data_length + index_length) / 1024 / 1024),2) 'Size in MB'
- FROM information_schema.TABLES WHERE table_schema = "HERE YOUR DATABASE NAME"
- ORDER BY (data_length + index_length) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement