calcole mysql tables dimension

HexisNou Jul 22nd, 2019 (edited) 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand