Advertisement
shapoval

Get size of db tables

Dec 28th, 2018
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.36 KB | None | 0 0
  1. SELECT
  2.      table_schema as `Database`,
  3.      table_name AS `Table`,
  4.      round(((data_length) / 1024 / 1024), 2) `Size in MB (data)`,
  5.      round(((index_length) / 1024 / 1024), 2) `Size in MB (Indexes)`,
  6.      round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB (Total)`
  7. FROM information_schema.TABLES
  8. ORDER BY (data_length + index_length) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement