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 )

[rwilkins108]

Hmm, I got xCache 1.2.1 working, but for some reason the Clogs keep on going up and up, much faster than anything else, plus it is always compiling... Searching on line other people have had the same problem, but doesn't look like there is a solution. My setup win2003 - Apache v2.2.3 - php5.2.4

PHP Code:

        Slots    Size    Avail     %  Compiling  Hits  Misses  Clogs  OOMs  Protected  Cached  Deleted  GC 
php#0  8.00 K  64.00 M  62.06 M         yes       0      10    5,111   0        no        9       0 


[xcache]
xcache.shm_scheme = "mmap"
xcache.size = 64M
xcache.count = 1
xcache.slots = 8k
xcache.ttl = 0
xcache.gc_interval = 0

; same as aboves but for variable cache
xcache.var_size = 64M
xcache.var_count = 1
xcache.var_slots = 8K

xcache.var_ttl = 0
xcache.var_maxttl = 0
xcache.var_gc_interval = 300

xcache.test = Off
xcache.readonly_protection = Off
xcache.mmap_path = "/dev/zero"

[hilfe-forum]

Love it...
Board index Loading Time goes to 15 sec (before 22 sec)
THX for this hack!

[lazytown]

Is there any way to disable this for certain mods or modify them to work with the xcache datastore?

If the datastore won't work, is there still some benefit to the filestore? I noticed that works with all my mods and Xcache actually caches it as a php file.

-vissa

[lazytown]

Originally Posted by hilfe-forum

Love it...
Board index Loading Time goes to 15 sec (before 22 sec)
THX for this hack!

Wow, but that's still a horrendously long load time!

[hilfe-forum]

Originally Posted by vissa

Wow, but that's still a horrendously long load time!

Not realy
Its only a dual Xenon with 2 Gig RAM an 3 Medium Boards:

http://forum.hilfe-forum.eu/
http://www.hilfe-forum.eu/hilfe-forum/
http://musik.hilfe-forum.eu/

the biggest Board ( http://www.hilfe-forum.eu/hilfe-forum/ ) have a Million Post and ca. 80 Hacks...

So 15 sec loading Time is very god

now i optimize the xcache seting now loading Time is 10 sec.

[Paul M]

15 seconds is not very good, it's poor.

vb.org has over a million posts, so does Cable Forum - it either of them took that long to load up i'd be worried.

[hilfe-forum]

Originally Posted by Paul M

15 seconds is not very good, it's poor.

vb.org has over a million posts, so does Cable Forum - it either of them took that long to load up i'd be worried.

But vb.org is 1 Board.
I have 3 Boards on 1 Dual Xenon with 2 Gig RAM
1. Board 900.000 Post 20 Hacks 600 Sub-Foren
2. Board 950.000 Post 80 Hacks 600-Sub Foren
3. Board 200.000 Post 1200 Sub-Foren (near 50.000 Post per Day per RSS Feed)

Thats not the same like vb.org
So i think for this is 15 sec. is very very good

(sorry for my bad english)

But back to Topik...

[lazytown]

Are you talking 15 seconds as reported by vbMicroStats or some other method? I have 3 large VB forums (almost 3mil posts together) on 1 dual xeon and have load times of less than a second on the forum home. Plus the server runs about 10 other busy sites, an online learning center, some old UBB forums, etc.. Of course I do have 4GB and scsi raid 5. Still, your server/vb must not be optimized.

-vissa

[hilfe-forum]

vbMicroStats reported 1-8 sec...
But real loading Time (DSL 12000) = ~10 sec.
My Server has only one IDE HDD
Most Time need the Hacks and RSS-Feeds
Showtread have 132 queries...
Page generated in 1,25929 seconds with 132 queries [Server Loads: 3.20 2.87 : 3.52]

Can any mod Post 145-149 move to here:
https://vborg.vbsupport.ru/forumdisplay.php?f=197
THX

[Deriel]

132 queries? Way too much Showthread is 12 queries in my board

Anyway, this is a really good MOD =] Thanks and congratulations!