Any of you fellow big boards using datastore caching in 3.6.x?

Any of you guys using APC/memcached/FileSystem datastore caching in 3.6.x?

I am wondering what query hits I will save on from enabling it.

Will I only save on a single select from the datastore table when a page is loaded?

I can't find much documentation on it another then how to enable it.

Have any of you guys noticed an improvement or any problems after enabling it?

[ubuntu-geek]

I am using http://trac.lighttpd.net/xcache/ along with the datastore and if I disable it I really can tell a difference in site performance. I found xcache to be alot faster then APC.

[Blackhat]

where can I find the settings for this?

[ubuntu-geek]

This works pretty well for me.. No complaints.

[xcache-common]
;; install as zend extension (recommended), normally "$extension_dir/xcache.so"
;zend_extension = /usr/local/lib/php/extensions/non-debug-non-zts-xxx/xcache.so
;; For windows users, replace xcache.so with php_xcache.dll
;zend_extension_ts = c:/php/extensions/php_xcache.dll
;; or install as extension, make sure your extension_dir setting is correct
extension = xcache.so
;; or win32:
; extension = php_xcache.dll

; required for >=php5.1 if you turn XCache on
auto_globals_jit = Off

[xcache.admin]
xcache.admin.user = "user"
; xcache.admin.pass = md5($your_password)
xcache.admin.pass = "somemd5password"

[xcache]
; ini only settings, all the values here is default unless explained
; to disable: xcache.size=0
; to enable : xcache.size=any size > 0 and your system mmap allows
xcache.size =                  96M
; set to cpu count (cat /proc/cpuinfo |grep -c processor)
xcache.count =                 2
; just a hash hints, you can always store count(items) > slots
xcache.slots =                16K
; ttl of the cache item, 0=forever
xcache.ttl   =                 0
; interval of gc scanning expired items, 0=no scan, other values is in seconds
xcache.gc_interval =           0

; same as aboves but for variable cache
xcache.var_size  =             96M
xcache.var_count =             2
xcache.var_slots =            16K
; default ttl
xcache.var_ttl   =             0
xcache.var_maxttl   =          0
xcache.var_gc_interval =     300

xcache.test =                Off
; N/A for /dev/zero
xcache.readonly_protection = Off
; for *nix, xcache.mmap_path is a file path, not directory.
; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection
; 2 group of php won't share the same /tmp/xcache
; for win32, xcache.mmap_path=anonymous map name, not file path
xcache.mmap_path =    "/dev/zero"


; leave it blank(disabled) or "/tmp/phpcore/"
; make sure it's writable by php (without checking open_basedir)
xcache.coredump_directory =   ""

; per request settings
xcache.cacher =               On
xcache.optimizer =           On

[xcache.coverager]
; ini only settings
; make sure it's readable (care open_basedir) coverage viewer script
xcache.coveragedump_directory = "/tmp/pcov/"

; per request settings, will be auto disabled if xcache.coveragedump_directory is not set
xcache.coveragedumper         = Off

[telc]

I am refering to the vbulletin datastore caching. Instead of having vbulletin use the datastore table, you can have vbulletin cache the values in memcached, apc, or filesystem.

[hilfe-forum]

i Use APC in comb. with Master Slave DB and Template Chace.
www.hilfe-forum.eu

No Probs.


ACP make Forum 20% faster
Master/Slave 30%
Template Chace 20%

[Erwin]

I use memcache. Support is built-in.

[telc]

I would like to know exactly what query hits we would save on by using the memcache. Would it just save from a single select statement to the datastore table? vBulletin does not give much information on this feature.

[ubuntu-geek]

Originally Posted by Erwin

I use memcache. Support is built-in.

Erwin how much ram do you start memcache with? Just curious.

[mute]

If you are using just the default vb stuff, you don't need much memory at all. The default 64mb is overkill even, you could get away with 32mb.