Guest User

Untitled

a guest
Apr 24th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT
  2. table_schema as `Database`,
  3. table_name AS `Table`,
  4. round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
  5. FROM information_schema.TABLES
  6. ORDER BY (data_length + index_length) DESC;
  7.  
  8.  
  9. SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;
Add Comment
Please, Sign In to add comment