Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- table_schema as `Database`,
- table_name AS `Table`,
- round(((data_length) / 1024 / 1024), 2) `Size in MB (data)`,
- round(((index_length) / 1024 / 1024), 2) `Size in MB (Indexes)`,
- round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB (Total)`
- FROM information_schema.TABLES
- ORDER BY (data_length + index_length) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement