Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 12 Mar 2007, 01:22
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Real name: Brent Wilson
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?
__________________
Whipp Media | http://www.admin-talk.com/
I buy forums. PM me.
Reply With Quote
Comments
  #2  
Old 07 Apr 2007, 20:29
ekool ekool is offline
 
Join Date: Jun 2003
Bump to the top...
Reply With Quote
  #3  
Old 07 Apr 2007, 20:34
orban orban is offline
 
Join Date: Jan 2005
Can you give a link to the source about Howard Stern's Forum? Thanks
Reply With Quote
  #4  
Old 07 Apr 2007, 22:15
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Real name: Brent Wilson
This discusses it

http://lists.danga.com/pipermail/mem...er/000793.html
__________________
Whipp Media | http://www.admin-talk.com/
I buy forums. PM me.
Reply With Quote
  #5  
Old 10 Apr 2007, 09:43
djdrey djdrey is offline
 
Join Date: Mar 2002
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?
Reply With Quote
  #6  
Old 18 Apr 2007, 00:09
djdrey djdrey is offline
 
Join Date: Mar 2002
No one? I guess I'll head into the slow query log and start there then
__________________
---
Sound Alliance
Our sites: inthemix.com.au | FasterLouder.com.au | SameSame.com.au
Reply With Quote
  #7  
Old 18 Apr 2007, 01:23
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Real name: Brent Wilson
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.
__________________
Whipp Media | http://www.admin-talk.com/
I buy forums. PM me.
Reply With Quote
  #8  
Old 19 Jun 2007, 23:26
gabrielt gabrielt is offline
 
Join Date: Apr 2007
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 http://www.vbulletin.org/forum/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.
Reply With Quote
  #9  
Old 19 Jun 2007, 23:53
ekool ekool is offline
 
Join Date: Jun 2003
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...
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 12:34.

Layout Options | Width: Wide Color: