[php] db 사용량 구하기.

$host="localhost";

$user_name="";

$db_password="";

$db_name="";

$dbcon = mysql_connect($host,$user_name,$db_password) or message(mysql_error());

mysql_select_db($db_name,$dbcon) or message(mysql_error());

$result = mysql_query("SHOW TABLE STATUS", $dbcon);

$total_size = 0;

while($dbData=mysql_fetch_array($result)){

        $total_size += $dbData["Data_length"]+$dbData["Index_length"];

}

mysql_close($dbcon);

printf("%0.2f MB \n",$total_size / (1024*1024));

참조 : http://www.xpressengine.com/phpClass/20386043