Board Optimization - datastore cache to XCache - boost your vBulletin

中文用户讨论@vbulletin-china.cn

(note: do not apply this patch on vBulletin 3.7 as it's included already)
This patch allow you to use XCache as a datastore cache in vBulletin. This is definitely your choice if you have installed and enabled XCache on you server already.

Take care that this is a beta version and was not heavily tested. And i'm not familiar with vBulletin source code as i just started reading it today, but i don't have any difficulty reading it thanks to my years of php skill

Take aware that some vB plugin is not compatible with vB_datastore_*, not just vB_datastore_XCache. So, in case you find vB_datastore_XCache won't work, you'd better try datastore to file or memcache. If one of the others works but not vB_datastore_XCache, do report it to me so i can fix it.

Pre-requirement

• a working php installtion
• a working vBulletin 3.6.5 installtion
• a working XCache installtion
• set "xcache.var_size = 10M" or so in php ini

Install the modification
for those of you who can't run "patch", u may patch the file manually

• download Attachment 61372 (class_datastore_xcache.php)
• save the file as vBulletin.3.6/upload/includes/class_datastore_xcache.php
• open vBulletin.3.6/upload/includes/class_datastore.php in your favor editor
• add a line in class_datastore.php (see below)
• update upload/includes/config.php to enable it (see below)

example class_datastore.php after modification:

PHP Code:

        }
        return true;
    }
}

// add class_datastore_xcache, enable it in config.php
require_once(DIR . '/includes/class_datastore_xcache.php');

/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:33, Fri Mar 2nd 2007
|| # CVS: $RCSfile$ - $Revision: 15474 $
|| ####################################################################
\*======================================================================*/ 


example config.php after modification:

PHP Code:


    // vB_Datastore_Filecache  - for using a cache file
// $config['Datastore']['class'] = 'vB_Datastore_Filecache';
$config['Datastore']['class'] = 'vB_Datastore_XCache';
    // vB_Datastore_Memcached - for using a Memcache server
    // It is also necessary to specify the hostname or IP address and the port the server is listening on 


Trouble Shooting
q. i have multiple vBulletin instance installed, the seems to mix data after install this plugin
a. this applies to apc too because, if you wanna fix it, try
open class_core.php, look for:
$this->prefix =& $this->registry->config['Datastore']['prefix'];
and modify to:
$this->prefix = $this->registry->config['Datastore']['prefix'] . $_SERVER['SERVER_NAME']; // or HTTP_HOST

q. Warning: unserialize() expects parameter 1 to be string, array given in $a.php on line $b
a. upgrade your plugin/hack that $a.php belongs to, e.g. vbjournal/vbgallery etc. OR open $a.php and locate at line $b, remove unserialize call, e.g.:
replace $var = unserialize($this->data);
with $var = $this->data;
be careful do not remove the whole line, just the unseralize( and )

[Zia]

Originally Posted by dbirosel

So if you have a big board going on, it's recommended to run something like this? I have many plugins installed, what plugins will it intefere with?

yes..this mods is really very nice...makes our forum smoother....as i found it(xcache) reduced more server load than eAcc reduced...after impliment datastore...still i didnt face conflict at all.......
u can give a try

[dbirosel]

Originally Posted by Zia

yes..this mods is really very nice...makes our forum smoother....as i found it(xcache) reduced more server load than eAcc reduced...after impliment datastore...still i didnt face conflict at all.......
u can give a try

Thanks for the reply! Do you have any plugins on your board? How many? Just want to make sure it's safe to install with the other plugins i have.


i have vbshout, CMPS, and more..

[Zia]

why not? yes there are......enough plugings installed with my board...

with xcache i didnt hesitate to install anything...

coz : the author of xcache & this hack..hes very much helpfull to solve users issue...
if u face any problem with xcache + this mods...u can just open a ticket HERE

be sure that u will get solution..like me & few others...untill things within his reach u will get the solution......
as per the thread no one face probs with vbshout yet.
just GARS.
tho some said vblogetin doestwork ..other hand some have it working...

welll..go for it..any probs report to mOo.

[kontrabass]

Sorry for my ignorance - but what is the advantage of using this hack, rather than just using vB_Datastore_Filecache and letting xcache cache the files?

[pollon]

I'm ignorant too about this Mod.
- Does this mod reduce the server load so my forum is faster?
- Are there any positive consequences to use of bandwith?

[Zia]

Originally Posted by kontrabass

Sorry for my ignorance - but what is the advantage of using this hack, rather than just using vB_Datastore_Filecache and letting xcache cache the files?

helo kontrabass, xcache will cache ur php file by defult.but if u want to cache ur database ..u can use it.
Yes there are positive out put for that.

I'm ignorant too about this Mod.
- Does this mod reduce the server load so my forum is faster?
- Are there any positive consequences to use of bandwith?

Yes..Xcache reduce server load & makes froum faster & smoother....& while u use this mods.. it will make ur forum more faster..like:
after install mods...
2 query reduced at my forum home....
and i was really wonder it reduce +4 query at aracde pages
so other pages...as i think...forum is more faster now

[NeutralizeR]

vBadvanced doesn't work. No modules are displayed.

Anybody has a fix for vBadvanced with XCache datastore cache enabled?

like this:
https://vborg.vbsupport.ru/showpost....5&postcount=55

[Zia]

Originally Posted by NeutralizeR

vBadvanced doesn't work. No modules are displayed.

Anybody has a fix for vBadvanced with XCache datastore cache enabled?

like this:
https://vborg.vbsupport.ru/showpost....5&postcount=55

hello...
please submit a ticket
http://trac.lighttpd.net/xcache/newticket

mOo is taking care of every single ticket related to vb...u will have reg. there (5 sec. register)

Please submit a ticket...with all the info...ur facing

Thanx.

[magnus]

Nice. Shaved my FORUMHOME queries to 5. Definately makes a difference, good job!

[da420]

Hey Zachariah,

Thanks for this, but where do I made these changes?

Originally Posted by Zachariah

I have not installed this but I have fixed PhotoPost vBgallery to work with Memcache.
- I think it will support other external cache programs also.

The problem was the way the original scripts are designed.

I do not have a full list but I am changing old calls to datastore items for vBgalery 2.2.

EX:

New:

$categorycache =& $vbulletin->gallery_c_cache;
$galleryoptions =& $vbulletin->adv_gallery_opt;
$gallery_permissions =& $vbulletin->gallery_ugroups;

vs. old way

$categorycache = unserialize($vbulletin->gallery_c_cache);
$galleryoptions = unserialize($vbulletin->adv_gallery_opt);
$gallery_permissions = unserialize($vbulletin->gallery_ugroups);

I have a windows system w/ memcache enabled and the gallery working with the new changes. With the current code in the gallery APC, Memcached setting stop the gallery from working.


I will also change the code to build datastore.

New:

build_datastore('name',serialize($field),1);

Old:

build_datastore('name',serialize($field));

Changes as these may also fix other scripts out there.