vb.org Archive - Quick Database Stats

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - Quick Database Stats (https://vborg.vbsupport.ru/showthread.php?t=51798)

assassingod

04-18-2003 10:00 PM

Quick Database Stats

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/showthrea...threadid=51828

assassingod

04-19-2003 01:07 AM

Screenshot:

DigitalDesktops

04-19-2003 01:32 AM

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

filburt1

04-19-2003 01:39 AM

From PHP.net user comments:

Code:

<?

/*

  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

04-19-2003 07:40 AM

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

Thanks filburt for the code!

assassingod

04-19-2003 02:21 PM

Updated Code

Still not sure if its probably workin as of yet

amykhar

04-19-2003 02:36 PM

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

04-19-2003 02:39 PM

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

amykhar

04-19-2003 02:41 PM

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

Amy

amykhar

04-19-2003 02:46 PM

Replace
return $size;

With:
return ($size / 1048576 );

All times are GMT. The time now is 10:06 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01100 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: