SHARE
TWEET

Untitled

a guest Jun 25th, 2019 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT table_schema "Database Name",  
  2. sum( data_length) / 1024 "data size in MB",
  3. sum( index_length) / 1024 "index size in MB",
  4. sum( data_free )/ 1024 / 1024 "free space in MB"
  5. FROM information_schema.TABLES GROUP BY table_schema;
  6.      
  7. mysqlcheck -o -A
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
 
Top