HexisNou

calcole mysql tables dimension

Jul 22nd, 2019
299
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.18 KB | None | 0 0
  1. MySQL [central_server]> SELECT table_schema "DB Name",
  2. Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
  3. FROM   information_schema.tables
  4. GROUP  BY table_schema;
Advertisement
Add Comment
Please, Sign In to add comment