Quick Search:
 
 mySQL: Get MySQL Database Size Jump to:  
Category: >> mySQL >> Get MySQL Database Size  

<< lastnext >>

Snippet Name: Get MySQL Database Size

Description: Useful shell commands for determining overall DB size.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

mysql -uroot -D db_development -e 
"show table status\G"| egrep "(Index|Data)_length" | 
awk 'BEGIN { rsum = 0 } { rsum += $2 } END { print rsum }'
 
-- another way:
 
echo "SELECT TABLE STATUS" | mysql-dbrc //DATABASE// | 
awk '{sum=sum+$7+$9;} 
END {print sum/1024/1024 "M"}'
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org