vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Memcached Beyond the Datastore (https://vborg.vbsupport.ru/showthread.php?t=141793)

BamaStangGuy 03-12-2007 12:22 AM

Memcached Beyond the Datastore
 
We all know Memcached support is built into vBulletin for the Datastore but that is it. Has anyone went beyond caching the Datastore? What did you cache and how has it affected your load time? Would you care to share how you did this?

I am looking to cache as much information as possible into the memcached server but like many who are not that familiar with PHP and vBulletin coding I don't really know where to start. I am willing to learn though. I'm not a complete moron when it comes to PHP but I still got a ways to go.

I was reading up on how Howard Stern's Forum has implemented Memcached into vBulletin and according to them they have cached like 70% of the forum in memcached causing their loads to drop from 5 to .5

This is what I am talking about. I have read people saying they were going to sit down and implement memcached throughout vBulletin on here but haven't seen any updates to this.

So what say everyone? :)

ekool 04-07-2007 07:29 PM

Bump to the top...

orban 04-07-2007 07:34 PM

Can you give a link to the source about Howard Stern's Forum? Thanks

BamaStangGuy 04-07-2007 09:15 PM

This discusses it

http://lists.danga.com/pipermail/mem...er/000793.html

djdrey 04-10-2007 08:43 AM

I'm keen to know what else people have done.. I did some hacking a little while ago (v3.5.x) to put the cached templates into memcache. After checking with Apache Bench, it didn't make a HUGE difference on individual page load. Maybe on a massive site it would help, but I think some of the existing template cache plugins are probably quicker already.

Keen to know what other areas everyone has moved into memcache. Anyone?

djdrey 04-17-2007 11:09 PM

No one? I guess I'll head into the slow query log and start there then ;)

BamaStangGuy 04-18-2007 12:23 AM

I don't have the technical know how to sit down and do it from scratch. I was hoping someone had at least something to go by. If you do do it I would love to see what you come up with.

gabrielt 06-19-2007 10:26 PM

Hi BamaStangGuy,

I am in the exact same position as you are right now. I am literally sweating to try lowering our servers load (see https://vborg.vbsupport.ru/showthread.php?t=148740). During the last 4 days I was dedicated to find bottlenecks and do some fine tunings, and I learned that Memcached is only used to store datastore... Accordigly to memcached stats datastore is only using 0.05 MB... I, like you, initially though it would be used to cache some other stuff as well.

Anyway. I am here to say that I would appreciate some tips on this issue as well. Like you, I know PHP/MySQL but don't know where to start, as I moved to vBulletin only very recently.

Cheers,
Gabriel.

ekool 06-19-2007 10:53 PM

Gabriel,

I replied to your post in the other thread. To address this issue, while memcached may not be caching A LOT of data, it is all very frequently accessed data. So, those are queries that mysql no longer has to deal with, so it is a big help...


All times are GMT. The time now is 01:08 AM.

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.01081 seconds
  • Memory Usage 1,725KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete