Queries

h@ck3r

New Member
Is there any way to see how many queries your forum is making on certain pages or whatever?

I'm looking to find out where queries are coming from, so I can decide what to do to make the browsing experience better for my members.
 
here u go homie...
might need a little editing....

heres one edit i found to fix it...

In init.php find:
Code:
$db->mstimer_start();
Below Add:
Code:
$db->timer_start('Including Functions.php');


This hack will add at the bottom of each vBulletin (powered) page, the statistics listed below.
Also, it will help you troubleshoot and optimize your vBulletin board by viewing or comparing PHP/MySQL options and other statistics that are normally hidden in your forum pages.

Regular Users:
• Load time of specified page in microseconds
• Number of queries executed
• PHP percent page usage
• MySQL percent page usage

Administrators Only:
• Active users browsing the forum (members and guests) new in 1.1.0
• Server memory usage per page (in Kb)
• Display DEBUG mode status
• Browser GZIP library compression status
• Server average loads
• Uncached templates (useful to troubleshoot the code)

The code modifications were tested into a clean installed vBulletin board. They work 100%.
The hack was tested in vBulletin 3.6.4 and 3.6.5.
If you want to test it into a lower version (3.6.x), let me know.
Also, if you encounter any problems, feel free to post your questions here.

Step by step install instructions are posted into readme.html file.
In order to perform an efficient modification of your files, I recommend you to use Komodo Edit or Textpad.
Both editors will allow you to complete all steps without any coding errors.

The code changes are very safe and designed not to interfere in any way with the vBulletin performance/functionality.
Make sure you modify, save and upload one file at the time to your server.
Then, simply run the product-vbmicrostats.xml file.

The PLUGIN itself is DISABLED by default.
This was done in order to make sure you properly edit your code first and to avoid surprises.
You will need to enable it, once your code modifications are completed:
Plugins and Products > Manage Products > vB Microstats > Enable (dropdown)
Then, go to your vBulletin Options, click on BB MicroStats setting group and set all your options.
 
Cheers, but what I want is some way of seeing exactly WHAT queries there are, so I know what is generating those queries.

Anyway this hack is no good for 3.8... I tried to install but got this:

The following dependencies were not met:

1. This product is not compatible with version 3.8.0 of vBulletin. (Compatible starting with 3.6.4 / Incompatible with 3.6.6 and greater)
 
Any other way?

I found this mod, but it doesn't list queries. Is it only queries that slow down a forum, or plugins etc too?

Can anyone explain a bit more to me?

I want to speed up my forums a little, without having to rent a decicated server.
 
Back
Top