vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Getting some data from mysql (https://vborg.vbsupport.ru/showthread.php?t=69985)

tschitschi 09-29-2004 10:40 AM

Getting some data from mysql
 
Don't knwo wheter to post it here or in the MySQL forum. If I'm wrong, please do move the thread.

I'd be happy if anyone could tell me, how do I get a number of things out of my vB mysql database (into a php script):
  1. number of records in the database (not in a table) and the disk space they use
  2. MegaBytes, which could be freed by optimizing all tables of the database
  3. database traffic since last reboot (overall, in, out)
  4. query cache + query cache allocation (in MB) (how may queries are in the cache)
  5. cache efficiency (hitrate) in percent
  6. key buffer + key buffer allocation (in MB)
  7. buffer efficiency (hitrate) in percent
It would be great if someone can answer this questions!

Thanx in advance, Gigi.

tschitschi 09-29-2004 12:10 PM

numbers 1,2,6,7 still missing. figered out the other stuffe by myself :)


All times are GMT. The time now is 01:42 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00929 seconds
  • Memory Usage 1,702KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete