Go Back   vb.org Archive > vBulletin Modifications > vBulletin 4.x Modifications > vBulletin 4.x Add-ons

Reply
 
Thread Tools
XCache for vBulletin Caching Details »»
XCache for vBulletin Caching
Version: 0.9.1, by rossco_2005 rossco_2005 is offline
Developer Last Online: May 2013 Show Printable Version Email this Page

Category: Board Optimization - Version: 4.x.x Rating:
Released: 01-30-2012 Last Update: 05-25-2013 Installs: 35
Code Changes Additional Files Is in Beta Stage  
No support by the author.

This mod will replace the default vB_Cache_Db class (database cache) used in vBulletin with an xCache implementation of it.
vBulletin has promised to implement this option themselves, but I'm sick of waiting, so I created this.

What are the benefits of using XCache for caching over MySQL (Database) ?

In theory, quicker page load times, lower server load. This will offload the duty of caching from mysql and throw it into the RAM.
It will also reduce your query count per page.

The most staggering difference you will notice is with the CMS, or any mods that make good use of the cache.
For instance, in my dev site using the default CMS content and settings, browsing as a guest, I was able to shave off an average of 0.06 seconds from the page generation time (0.23 -> 0.17 seconds) and 43 queries (86 -> 43)!
In a live site, the reduction in queries and overall time spent serving the page will have a large effect on overall performance in a busy site.

Make sure that you also have the datastore cache method set to xcache as well for further query reduction: https://www.vbulletin.com/docs/html/datastore
Also install "Load templates from XCache" for further query reduction: https://vborg.vbsupport.ru/showthread.php?t=255994

Any drawbacks?

Other than a file edit required on every vBulletin upgrade, none that I can think of... If you think of one, post it.

What about other data caches ? (memcached, apc, etc.)

I could write those as well, if there is a demand for it, and they happen to work similar enough to xcache.

This is a beta!

This has been tested in a live forum for a few days, and no incidents/side-effects have been noticed or reported, but I cannot yet guarantee it is 100% perfect.

This mod requires one file edit

See this bug to find out why: http://tracker.vbulletin.com/browse/VBIV-13241

Requirements

This was designed to fail gracefully by falling back on the DB cache if there is an error, so if there is an error you will not even realize it.

Make sure these requirements are met:
  • XCache 1.3.2 installed (only version that I tested) (verify by viewing phpinfo page)
The following are in your XCache ini settings (php.ini usually):
  • xcache.var_size = 32M (32MB; at least)
  • xcache.var_slots = 8k (8000; at least)
  • Set xcache.admin.user and xcache.admin.pass to whatever you want (keep in mind that the pass must be MD5'd)

Restart after making any changes.

Another tip is to set your xcache.count and xcache.var_count to the number of CPU cores that you have.

See the documentation here: http://xcache.lighttpd.net/wiki/XcacheIni

After running this mod for a while, check your xcache admin page to ensure that your var_slots and var_size are large enough.

Install Instructions

1. Upload the contents of the UPLOAD folder in xcache.zip to your forum root

2. Open up your /includes/config.php file and add the following:

PHP Code:
/*
 * XCache Config
 */
$config['xcache']['user'] = 'user';
$config['xcache']['pass'] = 'pass'
Edit it to include your xcache admin username and password

3. This step will need to be repeated whenever you do a forum upgrade.
Open up /vb/cache.php.
Find:
PHP Code:
self::$instance vB_Cache_Db::instance(); 
Replace with:
PHP Code:
self::$instance fst_Cache_Xcache::instance(); 

Download Now

File Type: zip xcache-0.9.1.zip (3.7 KB, 150 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
4 благодарности(ей) от:
FReeSTER, Max Taxable, steviewonder44, tbworld

Comments
  #22  
Old 02-01-2012, 12:58 PM
DNCL DNCL is offline
 
Join Date: Jul 2011
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do i have to enable XCache data store in config.php ?
Do i need to set the xcache admin pass in config.php?
What php handler i should use?
Reply With Quote
  #23  
Old 02-01-2012, 01:49 PM
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Posts: 1,158
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by DNCL View Post
Do i have to enable XCache data store in config.php ?
Do i need to set the xcache admin pass in config.php?
What php handler i should use?
you ned to make sure your your webhost allows it, or supports it
Reply With Quote
  #24  
Old 02-01-2012, 03:29 PM
DNCL DNCL is offline
 
Join Date: Jul 2011
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by simonhind View Post
you ned to make sure your your webhost allows it, or supports it
I;ve missed some note the dev wrote, the xcache must be enabled in config.php but the other 2 questions still need answer about best php handler for xcache because i'm getting internal server error with some of them, i'm using suphp atm.
Reply With Quote
  #25  
Old 02-01-2012, 04:25 PM
michael24179 michael24179 is offline
 
Join Date: Nov 2007
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

CMS problem. Categories in the CMS can not be called.

An unexpected error has occurred. Please try again later.
If the problem persists, contact the technical administrator.

Cache system can unfortunately not be deleted
Reply With Quote
  #26  
Old 02-01-2012, 04:44 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Interesting.
I started looking at this in the summer but had to put it on hold.
Might have to play with this a bit.
Reply With Quote
Благодарность от:
FReeSTER
  #27  
Old 02-01-2012, 10:23 PM
rossco_2005's Avatar
rossco_2005 rossco_2005 is offline
 
Join Date: Apr 2005
Location: Canada
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by DNCL View Post
I;ve missed some note the dev wrote, the xcache must be enabled in config.php but the other 2 questions still need answer about best php handler for xcache because i'm getting internal server error with some of them, i'm using suphp atm.
The datastore cache does not have to be set to xcache. That was only a recommendation.
The xcache admin user and pass must be set in config.php. Read the install instructions to see the code necessary to add to config.php to do this.
As for your question about a php handler, my mod does not care which you use, but xcache might need a specific handler - I'm not sure. You will have to ask google or look on the xcache website about installing xcache.
Reply With Quote
  #28  
Old 02-01-2012, 10:25 PM
rossco_2005's Avatar
rossco_2005 rossco_2005 is offline
 
Join Date: Apr 2005
Location: Canada
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by michael24179 View Post
CMS problem. Categories in the CMS can not be called.

An unexpected error has occurred. Please try again later.
If the problem persists, contact the technical administrator.





Cache system can unfortunately not be deleted
Do you have any mods installed? If so do you mind listing them?

Also what do you mean "cache system can unfortunately not be deleted."
Reply With Quote
  #29  
Old 02-01-2012, 10:33 PM
rossco_2005's Avatar
rossco_2005 rossco_2005 is offline
 
Join Date: Apr 2005
Location: Canada
Posts: 184
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by CoZmicShReddeR View Post
I am using it with 4.1.10 no issues... I run my own dedicated Server Box 2 Quad Core Xeon with 28GB Ram running it with Windows 2008 64 bit server hosting with XAMPP/Apache Friends just downloaded a windows version of XCache works fine... It did speed the load times up about 5% on the CMS home front and about 3% for the forums... Not sure how to tweak it using default settings or suggested settings...
Not sure which "default settings or suggested settings" your referring to, but here's basics of how to tweak xcache.
Actually there isn't really much to it.
Have a read here at what the different options affect:
http://xcache.lighttpd.net/wiki/XcacheIni

It would be useful for you to have xcache admin. It will tell you your cache sizes (php cache = xcache.size, var cache = xcache.var_size) in megabytes, and will tell you how many slots are available for each (php slots = xcache.slots, var slots = xcache.var_slots).
To see if you need to increase, or could get away with decreasing, those numbers, check how much memory is being used as well as how many slots are being used, then tweak accordingly.
If you are using all memory, you would increase memory.
If you are using all slots, increase the slots.
You want to leave extra room for the cache to grow, but keep in mind any memory you give to xcache takes away from memory available to the rest of the server, so it is up to you...
Reply With Quote
  #30  
Old 02-02-2012, 07:09 AM
michael24179 michael24179 is offline
 
Join Date: Nov 2007
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Cache system can unfortunately not be deleted


My Addons

404 Area 1.0
Admin Log In As User 3.21
Change Threads Prefix Inline 2.2.0
CT second_post_Ads 2.0.8
DownloadsII 6.0.9
Forum-wide Search For Unanswered Threads 4.2.0
Fussball Tippspiele 1.4.25 RC 1
MARCO1 Hide All 4.5
MGC chatbox Evo 3.0.0
Post Thank You Hack 7.82
Sids Hide Hack 0.9.8
Tabs en vBulletin 4.x 2.0.3
Template Modification System 1.2.0 Beta 4
Title Replace 1.1
vBulletin-CMS 4.1.10
vBulletin-CMS Links 1.0.0
VSa - Advanced Forum Rules 5.0.5
VSa - Sub-Forum Manager

My server
Operating System: Debian 6
Web Server lighttpd - cgi-fcgi
MySQL version 5.1.49-3
PHP 5.3.3-7 + squeeze6
Xcache Version 1.3.0
Attached Images
File Type: png cache.PNG (23.7 KB, 0 views)
Reply With Quote
  #31  
Old 02-02-2012, 12:35 PM
DNCL DNCL is offline
 
Join Date: Jul 2011
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm asking about if i really need to set the xcache user/pass in config.php because i couldn't authenticate to xcache admin panel until i turned off the admin authentication.
Is it ok?
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08339 seconds
  • Memory Usage 2,358KB
  • Queries Executed 28 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_php
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (5)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete