Memcached Beyond the Datastore

[BamaStangGuy]

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]

Bump to the top...

[orban]

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

[BamaStangGuy]

This discusses it

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

[djdrey]

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]

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

[BamaStangGuy]

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]

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]

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...