Guest User

Untitled

a guest
Apr 22nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. # single database
  2. SELECT SUM(((DATA_LENGTH + INDEX_LENGTH)/1024/1024)) AS "MB"
  3. FROM INFORMATION_SCHEMA.TABLES
  4. WHERE TABLE_SCHEMA = "wordpress";
  5.  
  6.  
  7. # all instance
  8. SELECT TABLE_SCHEMA as 'Database',
  9. SUM(((DATA_LENGTH + INDEX_LENGTH)/1024/1024)) AS "MB"
  10. FROM INFORMATION_SCHEMA.TABLES
  11. GROUP BY table_schema
Add Comment
Please, Sign In to add comment