[DBTech] vB Optimise 2.0.1 (Lite)

[Deceptor]

vB Optimise Lite

The newly revamped vB Optimise was created for vBulletin 4, but has now been made compatible for vBulletin 3.8. In this release I have re-coded vB Optimise from the gound and focused stability over features, you'll notice Phrase Caching and vBAdvanced Integration have bit the dust, this is to maintain a sync state between this version and the vBulletin 4 release.

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 (http://www.dragonbyte-tech.com/vboptimisesites.php)

Features


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 (https://vborg.vbsupport.ru/showpost.php?p=2015890&postcount=88) - Thanks to finereader (https://vborg.vbsupport.ru/member.php?u=72631)

Change Log

[>>] Version 2.0.1
New launch for vB 3.8

[>>] 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 (http://www.dragonbyte-tech.com).

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]

-Reserved-

[lazydesis]

the installation.txt file is empty :(

may be u forgot :D

will try after i know how to install .. i hope its straight forward upload files and import product :confused:

[Deceptor]

Sorry, forgot to hit save on that before zipping up. Try now :)

Also yes, no file edits.

[lazydesis]

in settings page you have

vB Optimise: Online/Offline
Use this setting to turn vB Optimise online or offline.

Yes = online or offline?

[Deceptor]

Yes = online :) I'll make that a little more clear in an update I guess.

[F0xy]

will it work on 3.7.x

[Deceptor]

Read the FAQ please :)

[Brandon Sheley]

interesting, will keep an eye on this one :)

[lazydesis]

*clicks install* got to see if it really increases the speed..how can i do that?

anyways thanks for the mod :)

[Deceptor]

Speed can vary depending on a number of factors, I found the best results occur when using Memcache. You could turn on vBulletin debug information to check page generation times, this is my forums normal generation time (forum home):

Page Generation 0.08814 seconds

This is simply a test forum, no mods but vB Optimise, my server also has XCache installed, when I turn vB Optimise on:

Page Generation 0.02804 seconds

Not to mention the reduction in two queries and a chunk off another :)

[veenuisthebest]

you joined two days back and brought a really nice thing pretty fast. Will test it out.

Can you please explain, which 2 global queries does it reduce and which one it chunks off.

thanks

[ssslippy]

This looks interesting and promising if it does what it says.

Question doesnt vbulletin already cache templates?

[KevinL]

Going to keep an eye on this one :)

[Deceptor]

Question doesnt vbulletin already cache templates?

vBulletin caches the template in a state ready to eval, but they are still called from the database on every page, but not with vBO :)

Can you please explain, which 2 global queries does it reduce and which one it chunks off.

The query to fetch templates, and the query to fetch the style are both removed. The fetch user info query is the one with the chunk taken out, that chunk being the language/phrases since vB fetches that when fetching the userinfo.

[lazydesis]

this doesnt allow me to select styles :( the default style is the only always shown .. is that correct?

[Deceptor]

this doesnt allow me to select styles :( the default style is the only always shown .. is that correct?
I'll check this out now, style switch should work, could possibly be a bug :)

[Deceptor]

Fixed, re-download and then re-upload the following file:
./includes/class_activecache.php

You'll be able to select styles correctly then :)

[Medtech]

Just what i was looking for, thanks!!!! *Installed*

[Medtech]

What extensions are you talking about?

vB Optimise offers the ability to use alternative methods to caching if you have the extensions installed on your server, it is recommended you use one of these instead of File Cache.

[Deceptor]

If you have XCache or Memcache installed on your server, you can choose either one in the vB Optimise settings, and vBO will use that instead of File Cache, as both are much better than using the file system to cache data.

[glorify]

Do you still have to enable xcache in your config.php if you are enabling thru the mod?

[Deceptor]

XCache does not need to enabled through config.php, nor does Memcache, but the memcache server info does need to be included in config.php :)

[glorify]

So if I have it enabled thru config.php, should I comment out?

[Deceptor]

Not at all, you can use XCache in config and for vB Optimise, or use Memcache in config and XCache in vB Optimise, it won't conflict :)

[glorify]

Thank you kind sir :)

[Deceptor]

No problem :)

[Medtech]

How well will this work with SEO or crawlers?

[Deceptor]

Won't effect either, this is purely improving performance. If anything I guess it means spiders won't add as much load as they used to :)

[glorify]

I get this when trying to flush the cache:

Fatal error: xcache_count() [<a href='function.xcache-count'>function.xcache-count</a>]: xcache.admin.user and xcache.admin.pass is required in /home/xxx/public_html/forums/includes/class_activecache_methods.php on line 161

[Medtech]

good, at times i have 700 members online with about 900 spiders, i have to turn off my plugin/ hook system so my forum does not lockup. using a VPS server. we will see what this does in a week when i get slammed again

[Deceptor]

You should recieve a prompt when attempting to flush the cache asking for your username/password, this is because your XCache is configured to require an admin username/password when using administrative XCache functions. Is the pop-up for authentification not showing?

This can be disabled through your php.ini:
xcache.admin.enable_auth = Off

[glorify]

Nope, not showing.

[Deceptor]

From what tests I've been able to do, the prompt should show on failure. It's possible the error haults this from happening, try the following change to see if it resolves your issue:

Open: ./includes/class_activecache_methods.php, Find:
for ($x = 0, $total = xcache_count(XC_TYPE_VAR); $x < $total; $x++)
{
if (xcache_clear_cache(XC_TYPE_VAR, $x))
{
$any = true;
}
}

Change this to:
for ($x = 0, $total = xcache_count(XC_TYPE_VAR); $x < $total; $x++)
{
if (@xcache_clear_cache(XC_TYPE_VAR, $x))
{
$any = true;
}
}

Find:
if (!isset($_SERVER['PHP_AUTH_USER']) && $x < 1)

Change this to:
if (!isset($_SERVER['PHP_AUTH_USER']))

Save and upload, let me know if this resolves the issue for you :)

[glorify]

You should recieve a prompt when attempting to flush the cache asking for your username/password, this is because your XCache is configured to require an admin username/password when using administrative XCache functions. Is the pop-up for authentification not showing?

This can be disabled through your php.ini:
xcache.admin.enable_auth = Off

Was able to get it using that workaround :)

Thanks. Didn't try the other lol.

[Deceptor]

No problem :) If you get a chance to try out the above changes to see if that works let me know how it goes.

[glorify]

I will, but I probably won't get the error now. Great work. Thank you. By the way, I am running RC1 and haven't upgraded to 2 yet.

[Deceptor]

Thanks for the note, it should run on beta installations of vB 3.8 too, but I won't swear by it :)

[lazydesis]

Fixed, re-download and then re-upload the following file:
./includes/class_activecache.php

You'll be able to select styles correctly then :)

thanks works as promised

1 question -- when i try to flush, it asks me for xcache username and passwd, when i give the ones i have in php.ini file, it says wrong. wat are these username and passwd?

also vboptimize directory has only 1 index.htm file? am i supposed to 777 this dir so vboptimize can write some files here?

[Deceptor]

You need to specify your username and password for XCache, remember the password in php.ini should not be an actual password, but an md5 encrypted password, then you enter the plain-text password in the prompt. Otherwise you can disable the admin authentification for XCache, see a couple of posts above to see how.

As for vboptimise/, yes it should have read/write permissions, as specified in the Admin CP descriptions when you setup vB Optimise :)

[TheLastSuperman]

Hmmm, forums seem a bit faster, let's see over the next day or so...

3.6.8

[Deceptor]

Glad to hear it's working on vB 3.6 :)

[Megatr0n]

Will this work on a shared hosting?

[Deceptor]

Yes Megatron, but you'll probably only be able to use the File Cache method, not Memcache or XCache. :)

[TheLastSuperman]

Glad to hear it's working on vB 3.6 :)

Still testing...

Seems fine though :D

Thanks, it was marked installed before previous post ;)

[Deceptor]

I've released 1.0.2, which fixes a minor bug and updates some other minor functionality regarding XCache users and Filecache, see the main post for further details, to update simply upload the files again and re-install the product XML :)

[glennybee]

Just had a play and I didn't see any difference in my page generation times. Currently using XCache on server but also tried Memcache and that was the same. It did cut down 2 queries on forumhome but that was about it.

Thanks anyway but think I'll disable it until more info is available.

[Deceptor]

XCache will do more work at cutting down load times and overall memory usage, that said, can I ask why you removed this despite two queries being cut down?

[goyo]

Thanks Deceptor...great work a much needed addon. :up:

vBulletin now use prefixes for xcache (in config) to avoid problems when 2 vbulletin used on a same server. Is your plugin ready to use it on multiple forums / same server with xcache method ?

[Deceptor]

goyo - currently the prefix is predefined, but I can punch out a 1.0.3 update right now if you like allowing you to specify a prefix for the XCache or Memcache items in the vB Optimise settings?

Also thanks, glad you like it :)

[goyo]

goyo - currently the prefix is predefined, but I can punch out a 1.0.3 update right now if you like allowing you to specify a prefix for the XCache or Memcache items in the vB Optimise settings?

Take your time. It's not needed right now...but it would be a nice feature (...not sure but maybe it would help some on shared hosts as well...)

Once again thanks. Your product is great and works well!

[glennybee]

Forgot to mention, there is a typo in the admincp page, the last option has the same description as one of the options above, can't remember exactly, thought you'd want to know.

[Deceptor]

I wasn't able to find a typo, but the descriptions do differ, just slightly though :)

[nascartr]

Seems quicker! Thanks! Had to use File Cache option.

[nascartr]

I wasn't able to find a typo, but the descriptions do differ, just slightly though :)


Under 'vB Optimise: Cache Phrases', it explains the description of caching templates....not phrases.

[Deceptor]

Thanks for that man :) Glad it's working good for yah.

[KevinL]

Worked beautiful. Dropped my load by about .3 Very nice work.

3.7.4

[unp]

Does it work with APC ?

[rob01]

how much memory the first option use?

other question.. why if i use the second option.. the queries jump from 18 to 45?

any idea?

:S cheers, nice release btw

[shlomot]

This add-on is mind boggling!!!

I'm not particularly concerned with bandwidth and resources in my communities, but said: what's the hack - let's give it a try.

Bottom line is: An amazing improvement in performance, page rendering, and customer experience.

Thank you from the bottom of my heart. NOMINATED.

[lolo?]

Does it work with APC ?

Same question for me :)

[Deceptor]

APC support will be coming in either 1.0.3 or 1.0.4, unfortunately I haven't had time as of yet to install APC on my server, but once I have I'll implement it into vB Optimise :)

I'm also glad to hear the positive effects this is having on peoples forums :)

[lolo?]

APC support will be coming in either 1.0.3 or 1.0.4, unfortunately I haven't had time as of yet to install APC on my server, but once I have I'll implement it into vB Optimise :)

I'm also glad to hear the positive effects this is having on peoples forums :)

Thanks a lot i'll be waiting for apc ;)
i have test with file cach and 1 query it's save great work :):)

[MrZeropage]

I will wait for APC-support, too, and then test this :)

[birdie]

Getting this error:vB Optimise: You have selected the File Cache method but the directory ./vboptimise does not have sufficient write permissions. Please chmod the folder then try submit these settings again. (Usually chmod 0777).
The folder is chmod 777

[birdie]

I also tried in on another forum and now the whole forum has gone!!! I quickly uninstalled all teh files and all I have left is this:Warning: Unknown(): Unable to access [path]/includes/class_activecache.php in [path]/includes/functions.php(1305) : eval()'d code on line 1

Warning: Unknown([path]/includes/class_activecache.php): failed to open stream: No such file or directory in [path]/includes/functions.php(1305) : eval()'d code on line 1

Fatal error: (null)() [function.require]: Failed opening required '/home/ru/run/xxxxxxxx.com/public/www/forum/includes/class_activecache.php' (include_path='.:/usr/local/lib/php/') in /home/ru/run/xxxxx.com/public/www/forum/includes/functions.php(1305) : eval()'d code on line 1
This absolute diaster! and I not sure how to fix it.

[unp]

I am using the file cache method and there is definitely a performance boost,waiting for APC support.
Nominated for MOTM :)

[birdie]

Its totally f...d up and corrupted the database on two forums. NOT HAPPY.

[GreasySpoon]

Does it work with TMS?

[logicuk]

How can i see if i have memcache on my server?

[goyo]

Its totally f...d up and corrupted the database on two forums. NOT HAPPY.

Birdie...It's a little strange that it works for everybody else...

What option are you using and what kind of server (also what php version) is that ?

[birdie]

Birdie...It's a little strange that it works for everybody else...

What option are you using and what kind of server (also what php version) is that ?
Its a shared host. I still trying to get to the bottom of it. Waiting to hear back from some people who know a lot more than I do about it.

[Leo Brazil]

I'm going to install this one on my test forum first to see how it goes. But the idea looks great. Save resourses = save $

Thanks mate.

[lolo?]

I also tried in on another forum and now the whole forum has gone!!! I quickly uninstalled all teh files and all I have left is this:This absolute diaster! and I not sure how to fix it.
Have you upload the file in the zip??
or have you delete the file and no unisntall the product?

[birdie]

Have you upload the file in the zip??
or have you delete the file and no unisntall the product?I have 6 forums; 4 with one host and two with another. I installed the mod on all 6 after it worked fine on one. The 4 with the one host worked fine; the two with the other host really got screwed up. They all in a shared hosting environment.

Unfortunatly, the host of the screwed up ones are not available (its currently 10PM Friday night in Australia). Fortunatly the hosts of the other 4 are available (they in a different country) and looked in to it for me. They have fixed one and given me the instructions to fix the other.

They said the problem is most likely the way the other host has the servers set up (I do not know what).

In case this happens to anyone else, this is the instructions they gave me:Login to FTP => go to your config.php file => at the very top of the
file you should see this code uncommented "define('DISABLE_HOOKS',
true);" un-comment the code and make it active then re-upload the file.
This turns off ALL plugins.

You should then be able to login the admin panel and un-install the vb
optimize mod.

After the mod has been removed then uncomment the code once again in the
config file to turn the plug-ins back on.

Thank you to the great folk at URLJet (http://www.urljet.com) for allowing me to not have a sleepless night over this one!

[Skyrider]

Installed on my 3.7 forums, thanks! :D Though, how can I test if the memcache works?

[Lizard King]

One of the best modifications i've ever seen at vb.org in the last couple years. Code is perfectly structured , doing its job perfectly.

Definately deserves to be the mod of the year.

[Skyrider]

One of the best modifications i've ever seen at vb.org in the last couple years. Code is perfectly structured , doing its job perfectly.

Definately deserves to be the mod of the year.
Indeed, also voted for NOTM.

[lolo?]

Indeed, also voted for NOTM.

+1 ;)

[Andreas]

Excellent work :)
Pretty similar to what I did (regarding the concept, your code is much better than mine!).

A few suggestions though:

Support for eAccelerator
User-definable prefix in cases where there are several installations on one server (maybe use the config.php setting?)
Hook into template_compile, css_output_build, admin_style_datastore to automatically flag cache dirty
Take care of custom datastore entries (if a datastore cache is being used) on init_startup to avoind the additional query


Does it work with TMS?
Partly - you must rebuild the cache manually afer TMS actions.

[GreasySpoon]

Partly - you must rebuild the cache manually afer TMS actions.

OK, thanks.

Just tried it, looks good.

Installed + Nominated

[Lizard King]

I'll also vote for the following option :

User-definable prefix in cases where there are several installations on one server (maybe use the config.php setting?)

[ForYou]

Hello ,

There is problem when i user the Quick Reply to post and when i click "post Quick Reply" you will not see the Theard but you see what you see in the photo .

Note : i'm using VbSeo also , is there any problem ,

http://www.dardasha.ps/montada/uploaded/1_01229697851.jpg

http://www.dardasha.ps/montada/uploaded/1_01229697906.jpg

I hope i can find solution ,

[KevinL]

Haven't seen this problem. I'm using vbseo also.

[ForYou]

What you think , from where the problem ,

[GreasySpoon]

What you think , from where the problem ,

Try to disable the GZIP compression in the AdminCP.

Some month ago, i had an error, with GZIP, whitch looked like that one.

[Robru]

Works fine for me with vB 3.8.0 RC1

Thanks you :)

[ForYou]

Hello ,

When i disable the GZIP the error still but in a diffrent way , look at the photo ,
http://www.dardasha.ps/montada/uploaded/1_01229701691.jpg

[GreasySpoon]

Did you modified something before you have installed this Add-on?

[ForYou]

NO , I don't do any thing just upload the files and import the product , maybe there is problem in setting and i don't know to do that or maybe there is some thing i need to do it ,

Please help if you can

[Deceptor]

birdie - Regarding your errors, it's because you installed the modification on the same server with multiple vB forums, I assume you used either XCache or Memcache? No doubt the cached items conflicted. This will be rectified in 1.0.3 where you're given the ability to insert custom data prefix's to ensure the cached content is kept unique to each individual vBulletin install.

ForYou - Unfortunately I've not been able to replicate this issue, if you could turn off cache phrases, then cache styles, then cache templates, and after each turn attempt to use quick reply again, to see if disabling any of the cache methods fixes the issue. If I'm right then it'll be phrases, since you're using a different language. That or something specific with your apache setup.

Andreas - Thanks for the kind words, and for the suggestions. I did consider eAccelerator but unless I'm mistaken vBulletin doesn't use it for a bug that occurs, if or not that will relate to vB Optimise I'm unaware of, but I'll look into to and if not integrate the controller.

As for everyone else, I'm happy to see the positive impact this is having on forums, I'll be releasing 1.0.3 very soon :)

[GreasySpoon]

Which type of caching did you choose? Try the filecache if it work.

Edit: Too late ;-)

[ForYou]

Still the same problem , :( please let me know step by step what can do to solve this problem ,

[ForYou]

still the same problem ,
http://www.dardasha.ps/montada/uploaded/1_01229705793.jpg

[Deceptor]

ForYou - Are you saying that after disabling all the caches you're still getting the error? If that's the case disable the product vB Optimise and see if you're still getting the error, if you are then it is being caused by something else.

[veenuisthebest]

oh man I can really see performance boost with this mod. And it did reduced 2 queries globally :eek: So nicely written, very well described settings, just amazing.

One question:-

I am using File Cache, I notice a lot of PHP files created in /vboptimise folder, can you please tell me how they are distributed, i mean on what basis that many php files are created.

Installed, nominated and Thanks a lot!

P.S.: If this was possible, why in the world vbulletin didn't do something like this, performance is the top thing. vBulletin should buy this code from you :D

[Deceptor]

Hi veenuisthebest,

The vboptimise/ folder will populate with the cache files created by vB Optimise, the basis that they are created on is 1 file per item, that item can currently be one of the following:

- A phrase
- A phrase group
- A template
- Style information (for 1 style)

Glad it's working out great for you :)

[Ramsesx]

After installing everything f** up and I get this error on a blank page:
Parse error: syntax error, unexpected T_STATIC, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/www/doc/15667/myhomepage
/www/forum/includes/class_activecache.php on line 11

[Deceptor]

Ramsesx - What PHP version are you using? You need to be using PHP5, there's no errors in the PHP files available to download, especially since your the first to report this error. Is it possible the files you uploaded got corrupted or uploaded in binary?

[Ramsesx]

Ok, my fault I thought I'm already on php5 but it's only 4.4.8. Any hints how I can get things on the road again? Somebody before said he disabled the hooksystem in the config.php, but on my file there is no line as described
Login to FTP => go to your config.php file => at the very top of the
file you should see this code uncommented "define('DISABLE_HOOKS',
true);" un-comment the code and make it active then re-upload the file.
This turns off ALL plugins.

[Deceptor]

define('DISABLE_HOOKS', true);

Simply place that in your config.php for vBulletin (./includes/config.php), it'll disable all your plugins, once do head into the Admin CP and uninstall vB Optimise product, you won't need to delete the vB Optimise files to remove completely, but your safe to do so after the product is removed.

After that, simply remove the line from config.php and your products will work again :)

[djr]

- Installed and nominated, thanks!

[Ramsesx]

Thanks a lot Deceptor now everything is fine again. :)

[Skyrider]

Sorry, had to disable this plugin. Using File Caching and had the bottom left 3 options enabled of the options menu, and a few hours later.. Seriously all the themes images disappeared. Only text was working:

Can you fix this issue?

Using VB 3.7

[Deceptor]

I'd need to be on an environment where the problem occured unfortunately to fix the issue as I'm unable to replicate myself, but I'll switch my test forum to filecache and watch it. Can I ask if you ever flushed cached over the hours you had it installed, or changed any settings with styles/phrases/templates?

Thanks.

[Deceptor]

FF|Skyrider, I've been able to replicate your issue by manually corrupting phrase cache files which broke images, to fix this in the next update I've applied an integrity check that will ensure the data fetched from cache is intact.

It should automatically detect and fix corruption issues with filecache on the fly without you ever noticing, so if you could let me know when the next version is released if you no longer get the issue that'd be great :)

[Skyrider]

I'd need to be on an environment where the problem occured unfortunately to fix the issue as I'm unable to replicate myself, but I'll switch my test forum to filecache and watch it. Can I ask if you ever flushed cached over the hours you had it installed, or changed any settings with styles/phrases/templates?

Thanks.
Installed it this afternoon, so it happened in the last 4 - 5 hours. And nope, haven't touched any styles,prhases or templates.

EDIT:
Saw your new post, thanks!

[tecnozul]

simplemete excellent at 3.7 and install it works perfect .. thanks
:D

[fattony69]

Didn't really read the thread, so I hope I don't repeat myself. Does this work with 3.7 and does it work with vbSEO?

[birdie]

Didn't really read the thread, so I hope I don't repeat myself. Does this work with 3.7 and does it work with vbSEO?Why not read the thread like the rest of us?

[tmc]

Good job. Looked through the code and was impressed. It's quite stunning there is no support for this in 3.8 by default.

This being PHP5-only certainly helps though.. :) I don't know how they'd quite manage otherwise, w/ 3.8's low requirements.

[Deceptor]

fattony69 - While 3.7 isn't the version this project is aimed at, people here have successfully installed it with no problems, the same applies to vBSEO.

tmc - Glad you like it :)

As for everyone else, the next update will be out in the next hour or so which will strengthen the cache system for the odd couple of people who've experienced corruption, and a lot of other additions too :)

[fattony69]

Why not read the thread like the rest of us?

I read the first post. I don't want to read posts about troubleshooting unless I have a problem.

[Infopro]

fattony69 - While 3.7 isn't the version this project is aimed at, people here have successfully installed it with no problems, the same applies to vBSEO.

tmc - Glad you like it :)

As for everyone else, the next update will be out in the next hour or so which will strengthen the cache system for the odd couple of people who've experienced corruption, and a lot of other additions too :)


I've edited the class_activecache_methods.php to set files in file cache to be created with 0644 permissions. (SuPHP and files set to 777 don't play well together)

[Magnumutz]

Deceptor... all i can say is, my hat down to you (a romanian word for "i've got the utmost respect for you").
Nominated for Mod of the Month poll.
You WILL win it and vBulletin SHOULD buy your code or at least ask for your permission to use it.

[Deceptor]

Infopro - Thanks for letting me know, I'll add a setting in the vB Optimise settings for SuPHP setups to swap auto chmod from 0777 to 0644 :)

Magnumnutz - All I can say is thank you, glad you appreciate the mod :)

[Deceptor]

Version 1.1.0 released :)

[veenuisthebest]

wow that was fast. Thanks for the super update deceptor!

[MrZeropage]

Thanks for this new version, and for apping APC-support :)

One more question: will this work having a forum running on more than one (in this case: six) different webservers having a load-balancer in action and using APC ?
I think the cache-folder will/could not be synchronous in this case, which could cause problems, right ?

[Deceptor]

Is the APC distributed across the servers or local to one server Zeropage? If it's local to one server there shouldn't be an issue, that said there shouldn't be an issue with distributed. Unfortunately I don't have 6 web servers at my disposal to test, haha, if you do happen to test let me know how it goes :)

[MrZeropage]

distributed APC on each of the servers, if I am not wrong ...

but I think there is currently no way to test this, as the site is productive and any problem would not be good ;)

Maybe later we can install a distributed test-environment.



One more wish:
include active support for TMS (by Andreas), meaning everytime a template-edit is done, your cache should be flushed

[1320Nation]

Installed on 3.7.3 using memcache and it's working with no problems. The board does appear to be running faster/smoother.

[Deceptor]

Well I'm not positive about APC, but I know distributed Memcache wouldn't be an issue because Memcache handles all the distribution, hopefully APC does the same thing.

If you'd like Zeropage, I could make a modification for you which will only activate vB Optimise for your user on your forum, that way any error that does occur will only be seen by you :)

[MrZeropage]

Deceptor, as this site is from a customer of mine, I will ask first. I will get back on you if they are interested :)


I am now using your 1.1.0 on another site (one server, normal) and activated it using APC. Should the setting in vB's config.php still be$config['Datastore']['class'] = 'vB_Datastore_APC';or would this "double" the caching into the APC if your AddOn is active, too ?

[Deceptor]

It would not double the cache with APC on vBulletin and vB Optimise. vBulletin will only use that for the datastore, what vB Optimise takes care of is different. I personally use Memcache for the vBulletin Datastore and vB Optimise with no issues :)

[Andreas]

Andreas - Thanks for the kind words, and for the suggestions. I did consider eAccelerator but unless I'm mistaken vBulletin doesn't use it for a bug that occurs, if or not that will relate to vB Optimise I'm unaware of, but I'll look into to and if not integrate the controller.

There was an issue with eAccelerator when that cache was full (eg. new items could not be inserted and those old values were loaded), but it has been fixed since 3.6.something were the logic was changed (items are now being deleted from cache when they need to be updated, so in worst case they are being loaded from db if the case is full).

[Deceptor]

Glad to hear it, I saw vBulletin has since put the eAccelerator class back in as normal so I figured it'd be safe :)

Thanks for the information.

[MrZeropage]

btw I am running this on 3.7.4PL1 without any problem :)

[KevinL]

Yeah this is mint :)

[veenuisthebest]

One more question deceptor,

I am using Filecache, with NO suphp.

My server undergoes a check every 24 hrs to identify any php files that are chmod 0777. If they find any, they are automatically set to 0644.

Can this cause some problem? Does vboptimise attempt to write to already created php files?

Thanks

[Deceptor]

veenuisthebest,

While vB Optimise will re-visit cache files, for reading and writing, if your server does this then chances are 644 is sufficient for both read/write perms, so it wouldn't matter :)

[veenuisthebest]

veenuisthebest,

While vB Optimise will re-visit cache files, for reading and writing, if your server does this then chances are 644 is sufficient for both read/write perms, so it wouldn't matter :)
great!

btw, works great on 3.7.3 and 3.7.4PL1 with/without vBSEO.

thanks :)

[MarkJW]

I was just about to post that my forum was having problems, then I noticed that 1.1.0 was out (I downloaded 1.0.2 earlier today, didn't expect a new version that fast lol). Then I read the notes and some of the thread and figured it must be a corrupted cache. Sure as heck, it was! Updating fixed it for the few members that were having problems. Thanks!

Running on AionSource.com, with a couple hundred people on at once (average). I can feel a difference!

Also, nominated. ;)

[Deceptor]

Glad to hear the update resolved the issue for you MarkJW :)

[logicuk]

i just installed this and now my site is blank!!

please help i cant do anything

vb 3.7.2

All i did was upload the xml and i got a white page and now my whole site is broke, and my site is a large forum

[Deceptor]

logicuk - Please ensure you're using PHP5, this will not work on PHP4 (as the FAQ states). No doubt your server doesn't display php errors and just displays a blank page, it won't be an actual issue with the cache system since when you install by default it is turned off.

You'll probably need to disable plugins to get back into your admin cp, to remove the product if you're not on PHP5, you can do this by editing /includes/config.php and adding this line:
define('DISABLE_HOOKS', true);

Once you've removed the product, you can remove that line from config.php to bring all your other products back online.

[MrNase]

It's working like a charm on vBulletin 3.7.4 :)


Before:

Page Generation 0,18873 seconds
Memory Usage 7,532KB
Queries Executed 17After:

Page Generation 0,56768 seconds
Memory Usage 7,543KB
Queries Executed 15

[logicuk]

logicuk - Please ensure you're using PHP5, this will not work on PHP4 (as the FAQ states). No doubt your server doesn't display php errors and just displays a blank page, it won't be an actual issue with the cache system since when you install by default it is turned off.

You'll probably need to disable plugins to get back into your admin cp, to remove the product if you're not on PHP5, you can do this by editing /includes/config.php and adding this line:
define('DISABLE_HOOKS', true);

Once you've removed the product, you can remove that line from config.php to bring all your other products back online.

omg thank you so much i thought my forum was ruined

Im using vb 3.7.2 PHP5.2.6 and i have memcache 3.0.1 installed

All i did was upload the xml and i got a blank page, how can i get this mod working for me?

[Deceptor]

logicuk - What version of PHP5 specifically are you running?

As for getting this to work, without an error I can't help much, I'd recommend uploading just the php files to your forum (don't install the product), then manually visit yoursite.com/forum/includes/class_activecache.php and class_activecache_methods.php, and see if you get any errors, ofcourse you will need to ensure PHP errors are being shown instead of surpressed.

If no errors occur there (you should see the message "Cannot access directly"), then it's possible another modification is conflicting with vB Optimise, if such is the case I'd be happy to help you figure out where the underline cause is and see what can be done to fix the issue :)

[logicuk]

logicuk - What version of PHP5 specifically are you running?

As for getting this to work, without an error I can't help much, I'd recommend uploading just the php files to your forum (don't install the product), then manually visit yoursite.com/forum/includes/class_activecache.php and class_activecache_methods.php, and see if you get any errors, ofcourse you will need to ensure PHP errors are being shown instead of surpressed.

If no errors occur there (you should see the message "Cannot access directly"), then it's possible another modification is conflicting with vB Optimise, if such is the case I'd be happy to help you figure out where the underline cause is and see what can be done to fix the issue :)

php 5.2.6

you will need to ensure PHP errors are being shown instead of surpressed

How do i do this?

And if i manually visit yoursite.com/forum/includes/class_activecache.php and class_activecache_methods.php is there any chance it will break my site?

[Deceptor]

PHP 5.2.6 should work fine, as for errors, check your php.ini for:
display_errors

Set this to On to display PHP errors. For more information see this page: http://uk.php.net/manual/en/errorfunc.configuration.php#ini.display-errors

[MrNase]

It's working like a charm on vBulletin 3.7.4 :)


Before:

Page Generation 0,18873 seconds
Memory Usage 7,532KB
Queries Executed 17After:

Page Generation 0,56768 seconds
Memory Usage 7,543KB
Queries Executed 15

Is it normal that it now takes more time to generate the page? I'm using the filecache? :)

[logicuk]

And if i manually visit yoursite.com/forum/includes/class_activecache.php and class_activecache_methods.php is there any chance it will break my site?

[Deceptor]

Filecache can differ depending on the hard drives your server has, for best results regarding page generation ideally you'd be using one of the other options. I've found XCache has the best impact on Page Generation along with Memcache.

Also, nothing will break, the scripts will simply tell you access denied, if they did break that would be a huge flaw, haha.

[TheLastSuperman]

Ok Deceptor, here's my report lol...

Loaded orig Version yesterday.
Pages seemed to load faster including info and ajax from other mods etc.
It makes switching forums faster i.e. we have several styles as we offer tournaments and it is helping them to load faster.... If you have not visited the forums that day it still loads the first time slow (which is fater now than before w/ vBo) but after that, it's like lightning in a bottle. Our forums do not "hang" as much waiting for all the data to catch up in the browser now lol.

Today w/ the update, seems the same.

So, per my previous post, 3.6.8 is running smooth.. I might be time to release it in the 3.6 Mod area as you know many will not attempt what I did as they lack experience w/ VB so best bet is to make a mod thread for it in 3.6.x forums so they can enjoy as well!

Thanks Again!

S-MAN

Edit: Ohh and as of this post, I Nominated MOTM ;)

[Deceptor]

Thanks for the detailed report Superman :p

I did consider posting it in the vB 3.7/3.6 areas, but to help keep track of everything and responses it's easier just to keep it here, be great if vBulletin.org had a system that allowed the thread to appear in multiple forums though, so people know it supports multiple versions (sounds like a good mod actually...).

[therogueforums]

VERY promising mod. I'll be keeping a close on this one :)

[TheLastSuperman]

Thanks for the detailed report Superman :p

I did consider posting it in the vB 3.7/3.6 areas, but to help keep track of everything and responses it's easier just to keep it here, be great if vBulletin.org had a system that allowed the thread to appear in multiple forums though, so people know it supports multiple versions (sounds like a good mod actually...).

I KNOW! I was thinking that myself after I first joined, it would cut down on hassle and us who do support to do it better IMO!

And - No Problem!

[Deceptor]

VERY promising mod. I'll be keeping a close on this one :)
Give it a try, won't bite :)

[GreasySpoon]

Thanks for importing eAccelerator.

Working fine.

[Deceptor]

I've prepped the next release for tomorrow, which currently includes:

- Optimal Settings Check System (will analyze your vB settings and see if any can be changed to improve performance).
- Kill Hook, so the vb optimise object is destroyed after it's used
- Fixed a minor bug, Force Datastore Cache still ran if vB Optimise was offline
- vB Optimise: Forumhome WOL Cache - Will cache your forumhome wol data for X seconds saving a query on your forum homepage

If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

[Medtech]

Suggestion.... in chief post.... big red letters... Do a database backup before you install this modification!

been reading all the posts here in this thread. users should be prompted to do a db backup since a lot of them seem to try installing without verifying php admin version. it may save them big headaches. the smart user will do a backup before installing any mod.

This mod has perfect code and works without any flaws as long as it is properly installed.

[Medtech]

another suggestion... i experience sluggish server and forums when i have 700+ users online at a time. would be nice if there was a part of this modification that would have a progressive plugin disabler to regulate the load on the server.

example would be for having a selectable choice for what gets shut down first, then second, and third and so on. i have 51 modifications installed at this time. i have to manually start shutting down modifications to lighten the load at busy times about once a week. would be great if vb would automatically do this. tired of seeing out of memory errors.

[Deceptor]

Thanks for the suggestions Medtech, as for the db backup, I see no need as vB Optimise doesn't affect the database in any way. At the most the product will cause php errors (dueto php requirements) and simply removing the product resolves that :)

As for the regulation, I might have an idea for that :)

[Medtech]

As for the regulation, I might have an idea for that :)

awesome!! i'll test it on 3.8.0 RC2

[lolo?]

thanks for APC now 4 query save on forumhome and 3 on thread :) nominate mom

[tmc]

I've prepped the next release for tomorrow, which currently includes:

- Optimal Settings Check System (will analyze your vB settings and see if any can be changed to improve performance).
- Kill Hook, so the vb optimise object is destroyed after it's used
- Fixed a minor bug, Force Datastore Cache still ran if vB Optimise was offline
- vB Optimise: Forumhome WOL Cache - Will cache your forumhome wol data for X seconds saving a query on your forum homepage

If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

Sexy. But really, it's the holidays.. Take a break!

:)

[Deceptor]

The break is the reason I've had time to do this :p

[logicuk]

Hello Deceptor I now have this working but i have a few questions

I have a single vbulletin install on my dedicated server i have memcache installed, what do i set this to? "vB Optimise: Data Prefix"

Also how can i check if its reduced my number of query's and made my pages faster?

And thanks again for the amazing work!

ps. i nominated this addon for addon of the month

[veenuisthebest]

I've prepped the next release for tomorrow, which currently includes:

- Optimal Settings Check System (will analyze your vB settings and see if any can be changed to improve performance).
- Kill Hook, so the vb optimise object is destroyed after it's used
- Fixed a minor bug, Force Datastore Cache still ran if vB Optimise was offline
- vB Optimise: Forumhome WOL Cache - Will cache your forumhome wol data for X seconds saving a query on your forum homepage

If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

oh man another query will drop then. You're going to make the whole forum run on cache soon haha.. :)

Hello Deceptor I now have this working but i have a few questions

I have a single vbulletin install on my dedicated server i have memcache installed, what do i set this to? "vB Optimise: Data Prefix"

Also how can i check if its reduced my number of query's and made my pages faster?

And thanks again for the amazing work!


ps. i nominated this addon for addon of the month


Data prefix can be anything, the description includes an example text as well.

It does clearly removes 2 global queries, To check it, you need to enable debug mode for your forum.

[Deriel]

Really nice Mod, nominated it already :)

I'm using vB 3.8rc2 and everything seems to be ok. Just one curiosity: using XCache with this mod seems faster than useing memcache (yeap, I have both installed)

[logicuk]

Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)

So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

[GreasySpoon]

If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

Maybe precaching the templates? So that the Add-On dont have to check if the Templates, Styles, ... are already cached or not?

Really nice work. Thumbs up :up:

[veenuisthebest]

Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??


Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

[logicuk]

Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

Yes this is the debug info for forum/index.php

I have enabled the mod and selected memcahce

And i cant disable any mods, my site is very custom

[tmc]

Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??
This is just plain wrong.. You don't even explain if it's on the EXACT same page. Seems to me like your website is adding extra queries per post or per thread, (I don't know what script you're taking this info from) and you happen to be comparing different pages.

It's not possible that this mod added 21 queries.

That being said, you really need to hire somebody to fix those query issues and the amount of memory being taken up. I don't quite get how the page you're loading is taking 16MB of memory...

Here's a SHOWTHREAD example: Page generated in 0.02043104 seconds (73.73% PHP - 26.27% MySQL) with 6 queries 2,085.35KB Used

and FORUMHOME: Page generated in 0.01459694 seconds (66.00% PHP - 34.00% MySQL) with 5 queries 1,470.00KB Used

[tmc]

Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.
I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

[logicuk]

I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

[Lizard King]

Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.
Yes you have a customized style but there is nothing extra on your forum index to run 33 queries

Edit : Sorry i just realized you are also using vbadvanced cmps. That explains everything

[tmc]

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)
As in: That's all it should be taking to pull this information onto FORUMHOME. Given it is properly coded.

It wasn't an actual observation, but my estimate of what your query count should really be. You should hire someone to optimize your queries, as they are probably destroying your server.

[veenuisthebest]

Deceptor, I have switched to xcache and I see much much better performace than filecache. Though I did not flushed the cache, just wanted to know why all is working fine for me without flushing the cache. I do have modifications, template edits etc.

Suggestion:

1. Can the forum titles be cached on index.php to reduce another query to extract all forums everytime.
2. Will the new feature of Forumhome WOL Cache, also cache the Statistics i.e. counts of threads, posts and members.

Thank you

[Bounce]

Installed...

Althou our forum is on a dedicated server there is a noticeable increase in speed :up:

[veenuisthebest]

1. I am facing a problem ONLY in 1.1.0 (this did not happened in 1.0.2)

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

There is no such problem using Filecache.

2. Another major problem I just found.

All member profiles look like as in attached pic, happens ONLY when viewed as guests. All phrases gone. It is happening only with vboptimise enabled, no matter what the cache type is.

thanks

[ssslippy]

1. I am facing a problem ONLY in 1.1.0 (this did not happened in 1.0.2)

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

There is no such problem using Filecache.

2. Another major problem I just found.

All member profiles look like as in attached pic, happens ONLY when viewed as guests. All phrases gone. It is happening only with vboptimise enabled, no matter what the cache type is.

thanks

I can confirm the profile bug.

[nascartr]

Profile problem here too...only when you're not logged in. Using Filecache method.

[shlomot]

Concur, using only file cache.

Profile problem here too...only when you're not logged in. Using Filecache method.

[veenuisthebest]

I can confirm the profile bug.

Profile problem here too...only when you're not logged in. Using Filecache method.

lol I am glad this is happening not just with me, so its a confirmed bug. Are you able to reproduce the first problem that I stated. Are you able to edit templates with vboptimise 1.1.0 using xcache?

Thanks

[Deceptor]

I'll get on fixing the bug right away. If you want a temporary fix for the profile issue, disabling phrase cache will resolve the issue.

Also, logicuk, the only possible way this mod adds queries is if it fails to cache the data, if you enable vBulletin debug mode you should see several vB Optimise messages explaining what it's doing, when first caching data it will execute more queries than vB does purely to cache the data, after that the query reduction begins. I'm assuming it keeps trying to cache the content but it's failing, if you're using filecache, ensure ./vboptimise has sufficient perms (read and write, usually chmod 0777).

[Bounce]

Deceptor,

I have eAccelerator installed on my server.
When I select this option I get this ...

vB Optimise: You have selected a cache method that vB Optimise has detected you cannot use, this may be because the extension required is either not installed or active on your server

Been using the file system but as it says

Additionally vB Optimise offers the ability to use alternative methods to caching if you have the extensions installed on your server, it is recommended you use one of these instead of File Cache. If you have multiple methods available it is advised you test each method and find the one that works and performs best for you.

I thought I'd try the eAccelerator option.

Thoughts?

[tpearl5]

I'm getting that phrase behavior when logged out as well. Disabled phrase caching and phrases are back.

Regardless I'm already seeing a performance increase. Nominated :)

[Deceptor]

hIBEES, if vB Optimise is reporting an error then the method must not be available, it will test you have the functions available that are part of the method you selected, this works in the same way vBulletin does, does your vBulletin datastore run off of eAccelerator?

As for the profile bug, it has been fixed, the issue is caused by caching phrases with guests, the vBulletin session object goes its own root of querying phrases/languages for guests that currently I can't find a way to stop. This bug fix doesn't impact performance as caching phrases for guests still means the query is being ran, if anything it slightly helps by not attempting to cache phrases as they are continually called from the database when viewing as a guest.

This said, I can tell you my current forumhome statistics with the upcoming release of vB Optimise, this is a unmodified forum, with only vB Optimise installed:

As a member:
Page Generation 0.03050 seconds, Memory Usage 924KB, Queries Executed 4

As a guest:
Page Generation 0.02649 seconds, Memory Usage 860KB, Queries Executed 3

If you're wondering why my memory usage is so low, look into getting XCache installed on your server, at the time of fetching those results vB Optimise was using XCache too, along with vB Datacache using Memcache.

I'll have the new version out in the next couple of hours or so which will patch the issue and bring forward new features I explained in an earlier post :)

[veenuisthebest]

Page Generation 0.03050 seconds, Memory Usage 924KB, Queries Executed 4
Page Generation 0.02649 seconds, Memory Usage 860KB, Queries Executed 3

now that is a real cake. waiting for the next release. :)

btw deceptor, can you please take a look at my 1st problem as described here (https://vborg.vbsupport.ru/showpost.php?p=1689613&postcount=174).

This started happening ONLY SINCE 1.1.0, and never happened with the last version 1.0.2

thanks

[Deceptor]

veeuisthebest,

Look at my above posts, the bug is fixed for the next release, to temporarily fix for now disable phrase caching, those won't add another query to your forum but will make more slightly bigger :)

[fattony69]

The only problem I had, which I searched the thread for was that my quotes, the name was only appearing as an underscore after installing this.

[Deceptor]

fattony, can you tell me if this occured as a guest or a logged in user?

Thanks.

[veenuisthebest]

veeuisthebest,

Look at my above posts, the bug is fixed for the next release, to temporarily fix for now disable phrase caching, those won't add another query to your forum but will make more slightly bigger :)
I know profile bug is fixed. I was referring to my 1st problem actually.

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

This problem is gone when i switch to Filecache. And this happened ONLY in 1.1.0 (did NOT happened in 1.0.2)

thanks

[Deceptor]

My apologies veenuisthebest, I missed that.

I know when updating templates vB Optimise kills current cache, my guess is your XCache requires authentification? It should silently carry on. That said, if you could enable php errors on your server we'd be able to specifically see what the problem is.

I'll re-enable admin auth on my XCache server and see if I can replicate the issue :)

[logicuk]

Also, logicuk, the only possible way this mod adds queries is if it fails to cache the data, if you enable vBulletin debug mode you should see several vB Optimise messages explaining what it's doing, when first caching data it will execute more queries than vB does purely to cache the data, after that the query reduction begins. I'm assuming it keeps trying to cache the content but it's failing, if you're using filecache, ensure ./vboptimise has sufficient perms (read and write, usually chmod 0777).

Im not using filecache, im using memcache..

[veenuisthebest]

My apologies veenuisthebest, I missed that.

Its just fine deceptor, np :)

I know when updating templates vB Optimise kills current cache, my guess is your XCache requires authentification?

ah I see! Yes, my xcache requires authentication but I cannot pass it as I am on shared hosting. I don't have rights to flush cache neither my host is turning it off as it is on a server level.

SO, the reason could probably be that whenever I edit a template, it stucks at flushing of cache, thus not saving the template, am I correct?

If that is the case, then I'll disable vboptimise (or switch to filecache for the moment) whenever I need to edit templates and switch it back ON when I would be done editing. Would that be fine?

I want to keep xcache only as its giving me far better performace than filecache and my host has installed xcache just for me lol :D

[Deceptor]

logicuk, could you turn on vBulletin debug mode, and take a look at the debug messages everytime you try to load a page and tell me what you see vB Optimise doing? As said, the only way it will keep adding queries is if it is failing to cache.

veenuisthebest, that solution would work, I assume you get a white page when attempting to flush the cache? Ideally I'd like to make it a little more solid, as in the future I'll probably be adding more places where the cache is killed to contend with new data, if your host could possibly turn on php errors so that you could tell me the error you're getting that'd be great :)

[fattony69]

fattony, can you tell me if this occured as a guest or a logged in user?

Thanks.

Seemed like it was for everyone from what I was told.

[Deceptor]

logicuk, I can't see any vB Optimise messages in the debug area, is it even turned on? If you could change the password to something more secure then PM me it, and grant me access to look at your vB Optimise settings I'll gladly take a look.

fattony, could you explain exactly how you encounter the issue? Sounds like a problem with phrases and it may be resolved as a similar bug has just been fixed.

veenuisthebest, I managed to replicate your issue, it seems that XCache haults the script on attempting to flush and the error cannot be silenced or stopped, so I've put a condition in that if the flush is meant to be silent (which it is when editing templates and such), and that your XCache requires authentification (specified by your vB Optimise settings), then the flush will simply skip and not attempt to clear the cache at all. Ofcourse a manual flush can still be achieved through the Flush Cache page, and this will only occur if your XCache requires authentification, for those lucky enough to turn it off the kill cache hooks will work fine with XCache :)

[veenuisthebest]

veenuisthebest, that solution would work, I assume you get a white page when attempting to flush the cache? Ideally I'd like to make it a little more solid, as in the future I'll probably be adding more places where the cache is killed to contend with new data, if your host could possibly turn on php errors so that you could tell me the error you're getting that'd be great

On attempting to flush the cache, I get the Xcache admin login window. No white pages anywhere.

In my phpinfo(), I have display_errors set to ON for local/master value under PHP Core. Let me know if that is what you were asking for.

I get no errors anywhere.

thanks

[Deceptor]

veenuisthebest, seems odd how a white page would occur. But not to worry, if you set your XCache Authentification setting to on, when you update to the next version it'll no longer occur when editing templates :)

[logicuk]

just sent you a pm deceptor :)

[veenuisthebest]

in the future I'll probably be adding more places where the cache is killed to contend with new data

That would be pretty cool. All the limits of shared hosting would overcome then.

veenuisthebest, seems odd how a white page would occur. But not to worry, if you set your XCache Authentification setting to on, when you update to the next version it'll no longer occur when editing templates

superb! :)

waiting for it badly. Was just wondering why this "Editing templates" problem occured in 1.1.0 as it was not in 1.0.2. Is this due to addition of xcache authentication setting?

Thanks

[Deceptor]

venuusisthebest,

The kill cache hooks were only introduced in the latest version, which is why it only occurs now :)

logic,

I took a look at your site, I believe one of many of your modifications is stopping vB Optimise debug messages, or other operations. I can see that file cache reduces one query on your forum, but Memcache is not doing anything. The problem there is something with your Memcache, do you have the correct settings filled in for your /includes/config.php?

To sum up though, vB Optimise isn't working right due to confliction, and since you have a -lot- of modifications installed it's very hard to tell where the problem occurs, you'd probably need to turn a product off one at a time, and keep checking your forums debug info each time (you need to look at the drop down menu, very bottom of the debug info). Once you start to see 'vB Optimise' messages in the drop down menu, we can start getting a clearer picture of what is going wrong. If turning off a product doesn't work, turn it back on and move to the next to continue.

Also, I have to ask if your vBulletin forum files have been modified? If so those too could be the root of the issue.

[logicuk]

logic,

I took a look at your site, I believe one of many of your modifications is stopping vB Optimise debug messages, or other operations. I can see that file cache reduces one query on your forum, but Memcache is not doing anything. The problem there is something with your Memcache, do you have the correct settings filled in for your /includes/config.php?

To sum up though, vB Optimise isn't working right due to confliction, and since you have a -lot- of modifications installed it's very hard to tell where the problem occurs, you'd probably need to turn a product off one at a time, and keep checking your forums debug info each time (you need to look at the drop down menu, very bottom of the debug info). Once you start to see 'vB Optimise' messages in the drop down menu, we can start getting a clearer picture of what is going wrong. If turning off a product doesn't work, turn it back on and move to the next to continue.

Also, I have to ask if your vBulletin forum files have been modified? If so those too could be the root of the issue.

ive sent you my config file via pm :)

[Deceptor]

Hi logic,

I checked out your config.php and found this part commented out:
$config['Misc']['memcacheserver'][$i] = '127.0.0.1';
$config['Misc']['memcacheport'][$i] = 11211;
$config['Misc']['memcachepersistent'][$i] = true;
$config['Misc']['memcacheweight'][$i] = 1;
$config['Misc']['memcachetimeout'][$i] = 1;
$config['Misc']['memcacheretry_interval'][$i] = 15;

You need to uncomment this section of code, or just copy what I put up there and place it anywhere inside your config.php - additionally you need ensure your memcache server is running on 127.0.0.1 (localhost) and port 11211 (usually is). The rest of the settings don't need modifying, but ensure the IP and Port is correct otherwise you may get errors when using Memcache on vB Optimise.

[veenuisthebest]

I'll post my suggestions again in case you didn't notice them.

Suggestions:

1. Can the forum titles be cached on forumhome to reduce another query to extract all forums everytime.
2. Will the new feature of Forumhome WOL Cache, also cache the Statistics i.e. counts of threads, posts and members.

Thank you

[ssslippy]

Please note when you install this mod the first view of any page will then put the item into the cache. That means those that just installed it and got more queries, vbulletin needs to put its data back into the cache after a clear.

Also on a side note if possible this should automatically use the pre built in data prefix that is in the config.php file.

[Deceptor]

ssslippy, I use a seperate data prefix just to ensure there's no collision with vBulletin :)

veenusisthebest,

Regarding #1, I'm looking into caching the forums now, it'd probably be a timed cache like the WOL will be, so the query can only be executed once every minute or hour if you like. Ofcourse the issue will be for those without auto flush cache due to XCache limitations like yourself may see stale data, since the last post info is updated regularly.

That said, if you put the timed cache for forums to 30 seconds, then the last post info data would ofcourse only have a maximum potential of being stale data for 30 seconds, and does reduce another query on several pages.

As for number 2, the statistics don't require a query as vBulletin already handles this with the datastore, assuming you have a decent datastore method (XCache/Memcache, etc..) setup with vBulletin then it's no problem, the only other query that might occur is when showing events from the calendar on the homepage, but these too are already cached by vBulletin.

Effectively the forum homepage only queries several things with the new version: Session, Userinfo, Forums and Moderators. This is only 4 queries, and ofcourse there are two other queries that execute as shutdown queries that occur on all vB pages (mostly, anyway).

If I can time cache the forums, and moderators part, the forumhome would go down to 2 queries (and the 2 hidden shutdown queries), which would be great :)

[Bounce]

does your vBulletin datastore run off of eAccelerator?

I have no idea lol (but judging from what you say I guess not),my host installed it,will ask them :up:

[veenuisthebest]

Ofcourse the issue will be for those without auto flush cache due to XCache limitations like yourself may see stale data, since the last post info is updated regularly.

So is there a solution for this? The ones who do not have auto-flush cache, how would they be able to see new data ever ?

And if I edit a template, how would I be able to view the change when the cache is not being cleared.

If I can time cache the forums, and moderators part, the forumhome would go down to 2 queries (and the 2 hidden shutdown queries), which would be great

oh man you are going to make all vbulletin sites run on cache completely haha.

Thanks

[Deceptor]

The solution would only be removing XCache authentification, or just going to Flush Cache each time you change anything with styles, phrases or templates. Ofcourse this still applies with other cache methods as vB Optimise does not always automatically refresh cache when data is updated, just currently on the common methods: edit templates, style variables, css information.

[logicuk]

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.19917 seconds
* Memory Usage 16,186KB
* Queries Executed 29 (?)

Great work Deceptor, nominated for MOTM :)

[veenuisthebest]

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.19917 seconds
* Memory Usage 16,186KB
* Queries Executed 29 (?)

Great work Deceptor, nominated for MOTM :)
You have a wonderful looking site logicuk, but compromising it with 16mb of memory (5 times the normal) and 33 queries (more than 3 times the normal) is way too much.

Optimizing your forum to reduce it to a considerable number would help you more than this mod :)

[logicuk]

You have a wonderful looking site logicuk, but compromising it with 16mb of memory (5 times the normal) and 33 queries (more than 3 times the normal) is way too much.

Optimizing your forum to reduce it to a considerable number would help you more than this mod :)

I have a dedicated server with dual core cpu and 4gb ram, its all good :)

[tmc]

I have a dedicated server with dual core cpu and 4gb ram, its all good :)
.... But then you're wasting loads of money a month on a server you shouldn't actually need.

Looking forward to the new release, Deceptor. :)

[Deceptor]

1.2.0 released :) Check the top post for details on bug fixes and additions :)

[logicuk]

i just installed 1.2.0 thanks for the new version

what setting do you recommend i use for Cache Forumhome WOL?

[Deceptor]

I personally would use between 30-60 seconds, ofcourse the higher the number the more stale the data becomes, but at a cost of better performance.

[bashy]

Hi

After upgrade i get this DB error now, its to do with the WOL part of your script

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.useragent,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity >;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
Error Number : 1064
Request Date : Saturday, December 20th 2008 @ 11:51:47 PM
Error Date : Saturday, December 20th 2008 @ 11:51:48 PM
Script : http://www.bashys-place.com/forums/index.php
Referrer :
IP Address : *******
Username : ************
Classname : vB_Database
MySQL Version : 5.0.67-

[Deceptor]

Bashy, are you using the homewol? Try disabling that to see if it works - be aware this is untested on vB 3.7, so I'm not sure if it will always work for that version.

[veenuisthebest]

just wow!

Loving the new Optimal settings check, I had all of them optimal already ;)

Profile bug down, can see another WOL query down. Cool

Template problem solved ONLY when XCache Authentification is ON.

Now, I tried to edit a template, the change did not show. Then I checked it again in a minute or two and it shows the edit fine. How did it show when I did/could not flush the cache ?

Thanks a lott.. You're one real php guy I had ever seen, this mod is going to beat the install counts of ibproarcade for sure. :)

[logicuk]

im using 1.2.0 and the WOL with vb 3.7 and its working fine :)

[Deceptor]

veenuisthebest,

The system maybe have found a corrupted template and pulled it again from the database to cache, which is part of the active sector of vB Optimise to ensure data is intact. Either that -or- your XCache has a low TTL (time to live) setting so cache is dropped every 5 minutes or so.

Glad you like the additions, I'll keep aiming to reduce the forum home queries as it's the biggest impact of performance being the most popular page visited on a forum, statistically speaking anyway :)

[Bounce]

ooooooooooooooooo nice update D...

WOL set for 60 secs :)

Had to optimize (or change)..
Store CSS Stylesheets as Files,Save Albums as Files,Save Avatars as Files..

Another 3 queries gone on forumhome:D..

Any faster and my forums will take-off LOL

[Deceptor]

Glad it's working great for you hibees :)

[logicuk]

My forum is so fast now its crazy! this has to be the best mod ever created!!

[Bounce]

Glad it's working great for you hibees :)

Thank you very much,voted for MOTM on version 1.1,this has to be MOTY :up:

Once I suss out eAccelerator then whoooffffffffff take off,not that my forums were slow as on a dedicated server with dual core cpu and 2gb ram but even at that this makes a difference..

I may not bother trying to get eAccelerator to work althou now i'm interested to see if it would improve it further..

Page Generation 0.19055 seconds on forumhome is just terrible :eek::cool::up:

My forum is so fast now its crazy! this has to be the best mod ever created!!

wots your url mate if you don't mind me asking, brilliant this eh :):D

[Deceptor]

Personally I'd recommend using XCache over eAccelerator, easier to install and much better in my opinion :)

[veenuisthebest]

Either that -or- your XCache has a low TTL (time to live) setting so cache is dropped every 5 minutes or so.

This is the reason, it has a low TTL.

Its fine if cache is dropped in few minutes. Infact, this solves out a big problem for me of not showing stale data now.

Loving vBulletin more from now on, just because of you and your vBoptimise. This is actually the BESTEST MODIFICATION EVER CREATED for vBulletin. I just can't stop thanking you deceptor, this has driven me crazyyy lol.

Thanks a lottt...

[KevinL]

Yup works no problem with 3.7. Excellent work.

[Bounce]

Personally I'd recommend using XCache over eAccelerator, easier to install and much better in my opinion :)

Thanks will look into it tomorrow(or later the day lol),better not mess with the server at this small hour (00:20GMT),plus had a few beers lol :up:

[NolF]

WoW incredible I jsut install it and I just cna feel the extra speed :) Could anyone tell me how to enable the Query number and execution time at the bottom of the page? I can't find the option. Would be cool to have quantitative data on how much this mod rocks :D

Installed and MOTD :DDDD

In 3.7.4 I found a curios bug which is not really a big deal. It you hace Store CSS as File disabled, and you try to enable it with this mod enabled only what is shown in the picture happens. Once disabled, you may enable Store as CSS and then enable the mod. Does this happen in 3.8?

Love it and thx mate :)

[Vitaly]

Bashy, are you using the homewol? Try disabling that to see if it works - be aware this is untested on vB 3.7, so I'm not sure if it will always work for that version.

I confirm. WOL doesn't work with 3.7.4, "database error". Must be disabled.

[Deceptor]

Nolf - I can confirm it works fine on my 3.8 install.

As for the debug info, it's this in your config.php:
$config['Misc']['debug'] = 1;

Vitaly - Some users have said it works on 3.7, others not, this is designed around 3.8 however. Could you tell me the db error that occured?

Thanks.

[NolF]

Vitaly I don't get a db error with WOL enabled :O (3.7.4)

Thx Deceptor :) just love the hack ^^

[lazee]

WOL .It work fine on my v3.7.2 board

Have anyone compare between the 1.0.2 and 1.2.0 version, my board used 1.0.2 it ran faster this morning and server load reduce from 0.67 to 0.45 , the 1.2.0 fast but the serverload reduce about half of the first one.

The only problem i got is every time i flush the cache it just never stop ( but it does clear the cache )

Deceptor: Thank a lot for this great plugin .

My spec: mysql 5.0.58 php 5.2.6 xcache v1.2.2

[Deceptor]

lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?

[lazee]

lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?

As i see on my board the 1.0.2 reduce server load more than the 1.2.0 does .

The 1.0.2 server load never over 0.85 when my board pass 600 user and guest
The 1.2.0 server load get to 0.95 sometime spike over 1.00 when it 530 user and guest

I used Xcache for cache method.

[Deceptor]

lazee - Are you using the new cache options available from 1.2.0? Like the ability to cache homepage wol and datastore methods?

I'm unable to confirm 1.2.0 adds more load than 1.0.2, especially given the impact that it reduces queries and page generation time further. In either case, if your forum is that active, a change in load from 0.85 to 0.95 is minimal, and given the number of background processes a server does it'd be hard to tell if vB Optimise caused the extra 0.1 server load, you're welcome to test however, I'd recommend watching load over the next few days and seeing if there are any changes.

Also check out your vB debug info, to verify cache is working correctly, and queries are being reduced :)

[lazee]

lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?

lazee - Are you using the new cache options available from 1.2.0? Like the ability to cache homepage wol and datastore methods?

I'm unable to confirm 1.2.0 adds more load than 1.0.2, especially given the impact that it reduces queries and page generation time further. In either case, if your forum is that active, a change in load from 0.85 to 0.95 is minimal, and given the number of background processes a server does it'd be hard to tell if vB Optimise caused the extra 0.1 server load, you're welcome to test however, I'd recommend watching load over the next few days and seeing if there are any changes.

Also check out your vB debug info, to verify cache is working correctly, and queries are being reduced :)

Yes, i do cache homepage wol and datastore methods.

I will watch couple day and see how the load difference and and turn on the debug.

Btw, it help a lot at server load compare to before i install this optimize, thank you!

[Deceptor]

Gotcha, and I'm glad to hear that overall it is helping you, certainly the direction I'm aiming for here :)

[SBlueman]

I went to activate this modification and got this error:

Fatal error: Call to undefined method vb_activecache::connect() in /home/sblueman/public_html/forums/admincp/options.php(1027) : eval()'d code on line 93

[Deceptor]

SBlueman - Try this patch:

Open ./includes/class_activecache.php, Find:
function set(){}

Underneath add:
function connect()
{
return true;
}

Save and upload, and try then. Overlooked this on my part, let me know if it works and I'll update the download :)

[Vitaly]

Vitaly - Some users have said it works on 3.7, others not, this is designed around 3.8 however. Could you tell me the db error that occured? Thanks.


Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.useragent,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity >;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
Error Number : 1064
Request Date : Sunday, December 21st 2008 @ 07:30:26 AM
Error Date : Sunday, December 21st 2008 @ 07:30:27 AM
Script : http://forum.rcdesign.ru/
Referrer :
IP Address : ****
Username : ****
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a

Have vb 3.7.4 + vbseo + memcached. Latest stable php + eaccelerator and so on...

Just enabled from admincp WOL=60 & refreshed main page. Other pages are ok.

Anyway, I'm not disapponted. WOL feature is not critical. Now vboptimise effect is not noticeable at my site, but will have to wait for middle of monday to compare.

[Deceptor]

Vitaly, if you disable vBSEO and enable the homepage WOL, does the error go away at all? :)

[SBlueman]

Looks like it saved....now.....what do I need to do to see if it's working properly? I am at http://gridironfans.com/

[Deceptor]

SBlueman - Enable vBulletin debug info to see if vB Optimise is working properly :)

[Deceptor]

Update: I've patched the release to 1.2.1 to fix the issue SBlueman discovered :)

[Vitaly]

I went to activate this modification and got this error:

I confirm.

1. Installed product. Not "enabled" in settings. Only defaults used.
2. Gone to settings, selected option "Keep CSS in file" and pressed "save"
3. Got the same error.

Then switched product off, did all settings, and enebled product again :)

[Deceptor]

Vitaly, the patch I gave SBlueman works, or you can update to 1.2.1 :)

[Vitaly]

Vitaly, if you disable vBSEO and enable the homepage WOL, does the error go away at all? :)

Sorry, I'm not ready to such extreme experiment, as disabling vbseo even for 1 minute at production site :) .

If you will not succeed to find problem in nearest days, PM me, i'll give you admin account at my "development" forum copy. It's busy now for another tasks.

[Vitaly]

Vitaly, the patch I gave SBlueman works, or you can update to 1.2.1 :)

Heh, your support is as fast and professional as at vbseo forums :)

Will do measurements in nearest days.

Btw, try to ask "happy installed people", how much of them use apache+mod_php instead of nginx/lighttpd+php_fcgi :) .

[Deceptor]

Off top of my head, probably a lot more, like 90% upwards. Ofcourse, if a vB mod could change that, I'd of already included it :p

As for disabling vBSEO, no worries, I understand how it is sometimes :)

[SBlueman]

I am running 3.6.8 and vbSEO and it seems to be working for me....although I don't know how to gauge that even after enabling the debug info.....bit of a noob when it comes to that.

[Deceptor]

SBlueman - After enabling debug mode, refresh your forum, and look at the very bottom for a drop down menu, click it and you'll see messages in there from vBulletin and vB Optimise, you should be seeing messages that say vB Optimise has fetched x, y and z from cache :)

[Vitaly]

Off top of my head, probably a lot more, like 90% upwards. Ofcourse, if a vB mod could change that, I'd of already included it :p

LOL. You have to introduce payed "pro" version with installation service :) . vboptimiser + nginx proxy at frontend...