Advertisement
fduran

calculate mysql schema disk size

Aug 14th, 2014
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. # calculate mysql schemas disk size
  2. mysql -h dbhost.example.com -u theuser -pThePassword -e 'select table_schema as DB, round(sum((data_length+index_length)/1024/1024),1) as MB from information_schema.tables group by table_schema order by MB desc'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement