Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)

vB Optimise Lite

This is ported from my original version released for vBulletin 3.8 located here. In this release I have re-coded vB Optimise from the gound and focused stability over features.

Professional version & feature list available @ www.DragonByte-Tech.com/forum
Priority support for Lite version is handled at the Developers Website.


What does it do?

vB Optimise is intended to optimise vBulletin software by integrating several PHP "cachers" and handling data before vBulletin. This works by encountering and handling data prior to vBulletin in order to skip the arbitary execution that would be more server intensive.

Real-Life Statistics

We've teamed up with some Big Forums to show you the impact of vB Optimise, you can view this public chart which shows both our statistics and theirs:

View Public vB Optimise Resource Statistics

Features - Lite

• Supported Extensions
  • APC
  • eAccelerator
  • Memcache
  • XCache
  • WinCache
  • Filecache
• Style Cacher
  Caches style data to globally reduce a query within all vBulletin forum-based pages.
• Template Cacher
  Caches template data to globally reduce a query within all vBulletin forum-based pages.
• Datastore Cacher
  Forces custom datastore items from modifications (including those from vB's blogs) to use your configured Datastore Cache method instead of being forced into the database. This reduces page queries by where affected.
• vB CMS Template Caching
  (Automatic) Corrects many uncached templates within vB CMS to reduce upto 20+ queries on CMS pages (number varies based on content).
• Optimal Settings Check
  Provides a quick interface to identify possible settings which can be changed on your forum for further optimisation.
• Self-System Tester
  Provides a relatively straight-forward system check to ensure your vB Optimise installation works fully.
• Automatic Cache Flusher
  Automatically flushes cache within the Admin CP based on specific triggers to make sure content does not remain stale on your forum.
• XCache Authentification
  Supports XCache Admin Authentification by allowing you specify the username/password in a configuration if needs be.

Features - Pro

• Notices Cacher
  Caches users dismissed notices to reduce a near-global query within all vBulletin forum-based pages.
• Showgroups Cacher
  Caches the showgroups query which becomes more intensive as your user-base grows.
• Forum Display Query Enhancement
  Enhances a stock vBulletin query within Forum Display to speed up the page.
• Forum Home WOL Cache
  Caches Forum Home "Who's Online" to remove an intensive query and allow larger sites to display this data without impact.
• vB Cache Override (Feature not available on vBulletin 3)
  Ability to override vBulletins new built-in database cacher for the CMS / Forum Sidebar Blocks to remove anything from 1 to 20+ queries based on your content.
• Full Guest Caching
  Ability to cache entire pages and serve them saving not only hundreds of queries but upto 90% of CPU processing towards Guests.
• Statistical Resource Savings
  Ability to see just exactly how many queries per day vB Optimise has saved your database. You'll be surprised at the numbers.
• Forum Resource Statistic
  Shows off vB Optimise resource saving statistics directly within forumhome statistics.
• ....and more!

Release Notes

If you've used vB Optimise before you'll be aware the previous version had phrase caching, however this caused complications with the way phrases are used within vBulletin so it has not been ported over at this time.


Available Translations
v1.6.0 French - Thanks to finereader

Change Log

[>>] Version 2.0.1
No change, just keeping in sync with vB 3.8/Pro

[>>] Version 1.6.1
Automatic Cache Flusher has additional parameters to make sure no data is stale
Resolved Bug: Potential PHP error when using eAccelerator which cannot flush within Admin CP on certain actions

[>>] Version 1.6.0
New OpCode Cacher Support: WinCache

[>>] Version 1.5.0
Resolved Bug: Style cache may have fetched ID 0 instead of correct file
Resolved Bug: Filecache permissions may not have worked
Optimisation: Re-wrote some base code to enhance operations.

[>>] Version 1.0.1
Added XCache Authentification Support
Added Filecache Support

Support

Priority support will be handled at DBTech.

FAQ

Q: I have WinCache installed, but vB Optimise tells me it's not?
A: WinCache only introduced OpCode support in version 1.1, if you're using version 1.0.x you will need to upgrade.

Q: I'm using the XCache method, flushing doesn't work?
A: If you have XCache authentification, turn the admin option on within vB Optimise Settings, then edit ./vboptimise/config.php and specify your XCache username/password. Alternatively you can disable XCache authentification within php.ini:

xcache.admin.enable_auth = Off

Q: I have eAccelerator installed, but vB Optimise tells me it's not?
A: eAccelerator does not provide the caching extension by default, you will need to recompile PHP with additional flags. For more information read eAccelerator documentation located here: http://eaccelerator.net/wiki/CompileConfiguration (Specifically look at: with-eaccelerator-shared-memory)

[Deceptor]

Those settings seem fine newsoftw, you've allocated 8MB to the var cache which should be far more than enough required. As my previous post explained, there isn't really any "optimal" settings, they can just be tweaked to favour your environment/preferences

[root's]

edit.. error thread

[Tize.]

I have error in all my tables and forum, users, user cp, admin cp .
Please help me!!!

PHP Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

                SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
                    
                FROM userlist AS userlist
                INNER JOIN user AS user ON (user.userid = userlist.relationid)
                LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
                LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) 
                
                WHERE userlist.userid = 33
                    AND userlist.type = 'buddy'
                    AND userlist.friend = 'yes'
                    
                ORDER BY RAND()
                LIMIT 0, 6;

MySQL Error   : Can't create/write to file '#sql_3dbb_0.MYD' (Errcode: 17)
Error Number  : 1
Request Date  : Sunday, September 26th 2010 @ 02:00:56 PM
Error Date    : Sunday, September 26th 2010 @ 02:00:56 PM
Script        : http://www.xxxxx.com/member.php?action=getinfo&u=33
Referrer      : http://www.xxxxx.com/
IP Address    : 83.39.77.914
Username      : Tize
Classname     : vB_Database 


[Tize.]

I am installing , desinstall the problem is this addon!!
Please help me!!!!

[Deceptor]

The query isn't generated or executed by vB Optimise, the MySQL error itself means the tmp directory is usually full, here's a topic on it over at vb.com: http://www.vbulletin.com/forum/showt...-file-...-quot

Hope that helps

[onehost]

Does not seem to be working, when I click save, the screen just goes blank...
so I can save any settings, then when I run a test, it just says its offline.

ideas?

[Tize.]

Originally Posted by Deceptor

The query isn't generated or executed by vB Optimise, the MySQL error itself means the tmp directory is usually full, here's a topic on it over at vb.com: http://www.vbulletin.com/forum/showt...-file-...-quot

Hope that helps

Thanks for the reply Depector.
Regards.

[ceho]

Hi, I am a newbie to this topic. I run 4.0.7 on a managed server where I cannot change any cache settings. Is this mod approved to be running with this vB version and does it make sense at all when you don't have a dedicated server where you can optimize everything the way you need it? I already did the possible optimization recommendatios by forums.digitalpoint.com, could this cause a conflict?

I would like to know more and test the lite version before spending money on pro, but only if it makes sense ;-).

Thanks!

[Deceptor]

onehost - Are you using XCache by any chance, or another cacher? If Xcache check the main post regarding XCache authentification.

Tize - You're welcome

ceho - The mod works on 4.0.7 just fine, as for making sense - the lite version reduces a couple of queries so why not If you're on dedicated you'll no doubt have plenty of ram - keep in mind you'll need a cacher system installed.

As for the DP suggestions - no confliction at all

[Skyrider]

vB Optimise 2.0.1 breaks "who's online" in 4.0.8