Linux System Administration
Thursday, April 2, 2009
MySQL: show disk space occupied by database
#mysql -uroot -p -D
-e "show table status\G"| egrep "(Index|Data)_length" | awk 'BEGIN { rsum = 0 } { rsum += $2 } END { print rsum/1024/1024 "M"}'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2011
(1)
►
December
(1)
▼
2009
(23)
►
October
(2)
►
September
(3)
►
August
(1)
►
July
(1)
►
June
(6)
►
May
(2)
▼
April
(2)
Generating a syslog message
MySQL: show disk space occupied by database
►
February
(1)
►
January
(5)
►
2008
(21)
►
December
(1)
►
November
(1)
►
October
(7)
►
September
(1)
►
August
(11)
About Me
RB
View my complete profile
No comments:
Post a Comment