Revisiting vBulletin Datastore Caching – memcached servers reducing MySQL server load
Back in March, I illustrated how two Litespeed web server based vB clients of mine were using vBulletin Datastore Cache feature + vB Optimise Pro plugin to offload some MySQL load to 2x or 4x Memcached servers. You can offload caching to APC Cache or Xcache as well if you don’t have Memcached installed.
I thought I’d check up on their progress so far. From below stats, it’s safe to say vBulletin Datastore Cache and Memcached servers are doing their job in reducing MySQL server load!
vBclient #1 – vB datastore cache + vB Optimise Pro plugin
- Update: I recently was re-hired to migrate this client’s multi-server setup to newly upgraded servers, so with upgraded PHP and Memcached server versions, I re-setup vB Optimise Pro for them and with their increased traffic over 4x Memcached servers their first 31 days of uptime served 3,600+ cache hit/sec for just under 4,000 requests/s to total 10 billion cache hits for their first month!
- With 4x Memcached servers running for >240 days uptime, served 2,740 requests/s with a 2,504 cache hits/s average over 240 days
- vB Datastore Cache via Memcached servers saved and offloaded from MySQL server a total of 52 billion cache hits over 240 days at 91.4% cache hit rate!
– vB datastore cache + vB Optimise Pro plugin
- With 2x Memcached servers running for >249 days uptime, served 346 requests/s with a 297 cache hits/s average over 249 days
- vB Datastore Cache via Memcached servers saved and offloaded from MySQL server a total of 6.39 billion cache hits over 249 days at 85.8% cache hit rate!