Quick Database Stats

[assassingod]

Quick Database Stats

Author: assassingod

Description: This hacks gives a quick list of database stats for your forums. Includes name and ammount of MB its using

Final hack:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=51828

[assassingod]

Screenshot:

[DigitalDesktops]

hmm it doesn't work. it says my database is using 0 MB, But mine is really using 4MB :(

[filburt1]

From PHP.net user comments:

<?
/*
Function that returns whole size of a given MySQL database
Returns false if no db by that name is found
*/

function getdbsize($tdb) {
$db_host='localhost';
$db_usr='USER';
$db_pwd='XXXXXXXX';
$db = mysql_connect($db_host, $db_usr, $db_pwd) or die ("Error connecting to MySQL Server!\n");
mysql_select_db($tdb, $db);

$sql_result = "SHOW TABLE STATUS FROM " .$tdb;
$result = mysql_query($sql_result);
mysql_close($db);

if($result) {
$size = 0;
while ($data = mysql_fetch_array($result)) {
$size = $size + $data["Data_length"] + $data["Index_length"];
}
return $size;
}
else {
return FALSE;
}
}

?>

<?
/*
Implementation example
*/

$tmp = getdbsize("DATABASE_NAME");
if (!$tmp) { echo "ERROR!"; }
else { echo $tmp; }
?>

[assassingod]

Thanks DigitalDesktops for the letting me know it doesnt work:)

Thanks filburt for the code!

[assassingod]

Updated Code

Still not sure if its probably workin as of yet

[amykhar]

It's not working properly for me.

It tells me that my db is vbulletin (Using 286524241 MB of space)

In fact, it is using 273.3 MB

I just now downloaded the code; so I assume I have the latest version.

Amy

[assassingod]

OK, Amy, I will look into that now. Thanks for testing it

[amykhar]

The result needs to be divided by 1,048,576 to get the correct answer in MB.

Amy

[amykhar]

Replace
return $size;

With:
return ($size / 1048576 );

[assassingod]

The original code did that:o

Thanks Amy, does it work for you now?

[amykhar]

Yes. It works now.

Amy

[assassingod]

You help is appreciated. I can put this in final release now:)

[DigitalDesktops]

Today at 02:39 AM filburt1 said this in Post #4 (https://vborg.vbsupport.ru/showthread.php?postid=384002#post384002)
From PHP.net user comments:

<?
/*
Function that returns whole size of a given MySQL database
Returns false if no db by that name is found
*/

function getdbsize($tdb) {
$db_host='localhost';
$db_usr='USER';
$db_pwd='XXXXXXXX';
$db = mysql_connect($db_host, $db_usr, $db_pwd) or die ("Error connecting to MySQL Server!\n");
mysql_select_db($tdb, $db);

$sql_result = "SHOW TABLE STATUS FROM " .$tdb;
$result = mysql_query($sql_result);
mysql_close($db);

if($result) {
$size = 0;
while ($data = mysql_fetch_array($result)) {
$size = $size + $data["Data_length"] + $data["Index_length"];
}
return $size;
}
else {
return FALSE;
}
}

?>

<?
/*
Implementation example
*/

$tmp = getdbsize("DATABASE_NAME");
if (!$tmp) { echo "ERROR!"; }
else { echo $tmp; }
?>


where do i place this code?

EDIT: nvm found it :)