Advertisement
zvinger

Untitled

Jan 16th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.24 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. where table_name not like "stat_%"
  7. ORDER BY (data_length + index_length) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement