PDA

View Full Version : Memcached Beyond the Datastore


BamaStangGuy
12 Mar 2007, 02:22
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
07 Apr 2007, 21:29
Bump to the top...

orban
07 Apr 2007, 21:34
Can you give a link to the source about Howard Stern's Forum? Thanks

BamaStangGuy
07 Apr 2007, 23:15
This discusses it

http://lists.danga.com/pipermail/memcached/2004-October/000793.html

djdrey
10 Apr 2007, 10:43
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
18 Apr 2007, 01:09
No one? I guess I'll head into the slow query log and start there then ;)

BamaStangGuy
18 Apr 2007, 02:23
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
20 Jun 2007, 00:26
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.

ekool
20 Jun 2007, 00:53
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...