Microstats - load times, server loads, queries, uncached templates

This is a derivative of Erwin's microstats hack for vBulletin 3.5.0's plugin system. The main difference is that by default it shows the page generation time and query count to the public. Server loads and Uncached Queries are shown only to administrators.

I had sent this to Erwin so he could release if he wanted to but instead he told me that I had permission to release it; hence why I am releasing it.

This should work with vBulletin 3.5.0 RC 1 through vBulletin 3.6.1 and later.

Installation is very simple. Just import the plugin via vBulletin's "Download / Upload Plugins" page in the Plugin System in the Admin Control Panel and you're done.

I'll try to correct any bugs that you find. Let me know if you like this plugin and don't forget to click the install link if you install this.

Optional config.php Variables

$config['Microstats']['replacementvariable']

Setting this variable will make microstats place its data before any instance of whatever you set this variable to. Be careful with this as you might see microstats in mutiple places. My suggestion is to use a unique comment in the HTML source to prevent any issues.

E.g. $config['Microstats']['replacementvariable'] = '<!-- display microstats here -->';

$config['Microstats']['adminonly']

Setting this variable to anything will make microstats display itself only to administrators.

E.g. $config['Microstats']['adminonly'] = true;

Update History

Product File: Uploaded a product file that replaced the plugin file.
Version 1.2.1: Fixed a bug that broke optional config.php settings
Version 1.2.0: Added OpenBSD, FreeBSD and NetBSD support; added Replacement variable setting in config.php; added Display only to Administrators Setting in config.php; fixed bug affecting Linux/Unix servers that have exec('uptime') support and not /proc/loadavg support
Version 1.1.0: Added names of uncached templates, included a bugfix for people who don't have proc avaliable on their system and made the code look a little nicer as well
Version 1.0.1: Bugfix for Windows users, sanitized the code to make it look nicer
Version 1.0.0: Initial Release

[MissKalunji]

what hack do you have?

[cavyspirit]

36:

Add PhotoPost Pro to each forum
Archive Adsense
BBcode templates manager
Cafe Press Add On
Catagory Icons
Enhanced Captcha Image Verification
FlashChat Integration
Global Announcement
GTSearch: Google™ Custom Search Engine
Guest Tracking
IpInfo
Latest X Threads on Forum Home
Left Column
Members who are using flashchat
Members who have Visited
Microstats
Mini Navbar
Miserable Users
Moderation Auto-PM
Multiple Login Detector
NoSpam!
Per-Thread Moderation
Post Thank You Hack
Real ip detection
Separate Sticky and Normal Threads
Show Birthday Icon in Postbit
SR Classifieds Premium 1.0.5
Sticky-Blue
Total Thanks - Forum Home Stats
vB Ad Management
vB Ad Management English language
vbgooglemap by StonyArc
vBSEO
vBSEO :: Sitemap Generator
Viper's YouTube & Google Video
Welcome Headers

[fly]

Originally Posted by cavyspirit

My forum is really slow to load pages at certain times of the day.

I got:
Page generated in 18.34197 seconds with 14 queries [Server Loads: 5.68 2.76 : 1.35]
Then, once in and doing a refresh, I got:
Page generated in 1.84214 seconds with 14 queries [Server Loads: 1.18 2.15 : 1.34]

I'm running a virtual private server and according to my host, utilization all the way around is very low. Upgrading to a dedicated server supposedly isn't going to buy me anything.

I like the hacks that I have, but it seems something(s) gotta go. I just took one rss javascript feed out of the left-hand column, but it looks like more's gotta go. Bummer.

I'm not sure what the server load numbers really mean.

I'm currently on 3.6.4 waiting for 3.7 gold to upgrade.

I thought the stats would show more queries based on my hacks, so now I'm not sure how to tune.

www.guineapigcages.com/forum/index.php

Those loads are high. Try disabling like 5 hacks at a time and see if you can narrow it down to a certain hack. Or turn off all plugins by editing config.php and see if load times stay the same. If so, you either have too many users for the server or vB isn't the problem...

[MissKalunji]

Originally Posted by cavyspirit

36:

Add PhotoPost Pro to each forum
Archive Adsense
BBcode templates manager
Cafe Press Add On
Catagory Icons
Enhanced Captcha Image Verification
FlashChat Integration
Global Announcement
GTSearch: Google™ Custom Search Engine
Guest Tracking
IpInfo
Latest X Threads on Forum Home
Left Column
Members who are using flashchat
Members who have Visited
Microstats
Mini Navbar
Miserable Users
Moderation Auto-PM
Multiple Login Detector
NoSpam!
Per-Thread Moderation
Post Thank You Hack
Real ip detection
Separate Sticky and Normal Threads
Show Birthday Icon in Postbit
SR Classifieds Premium 1.0.5
Sticky-Blue
Total Thanks - Forum Home Stats
vB Ad Management
vB Ad Management English language
vbgooglemap by StonyArc
vBSEO
vBSEO :: Sitemap Generator
Viper's YouTube & Google Video
Welcome Headers

yeah try what the othe rperson said and you can also post a server optimization on vb.com it helps a lot are you on dedicated? or shared?

It took me : Page generated in 115.71136 seconds

Keep in mind that some like :latest x thread are server intensive some aren't build for active forums as well....

The number of queries isn't all but also how heavy a query is


i also notice that your forum itself isn't slow ONLY the main page....so it could be that your problem?

[Traxdata]

working on 3.7 Gold! Great!

[MissKalunji]

*co-sign*

[mrahul]

work for 3.7.x and any releases planned ?

[Kinneas]

Originally Posted by mrahul

work for 3.7.x and any releases planned ?

I'd say no, considering the Author of this one hasn't posted since 2006. The good news is this one still works fine on 3.7.

[mrahul]

that's great, where ever the author is 3cheers for his excellent coding to be working on 2 later releases too :up:

[Artes_Marciales]

Thanks Work fine 3.7.1 : )