vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Any of you fellow big boards using datastore caching in 3.6.x? (https://vborg.vbsupport.ru/showthread.php?t=129463)

telc 10-19-2006 01:05 PM

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 10-19-2006 02:31 PM

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 10-22-2006 07:16 AM

where can I find the settings for this?

ubuntu-geek 10-22-2006 04:25 PM

This works pretty well for me.. No complaints.


Code:

[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 10-23-2006 12:18 AM

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 10-23-2006 04:24 PM

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 11-02-2006 03:32 AM

I use memcache. Support is built-in.

telc 11-03-2006 01:26 PM

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 11-11-2006 01:51 AM

Quote:

Originally Posted by Erwin
I use memcache. Support is built-in.

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

mute 11-11-2006 11:28 AM

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.


All times are GMT. The time now is 02:59 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01048 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete