vBulletin Datastore Cache – using Memcached cache to reduce MySQL database load
vB Client #2
Just checked another client’s vBulletin v4.1.2 forums stats, which is utilising 2x Memcached v1.4.5 server instances on a single server setup for web + db on a Dual Intel Xeon E5620 2.40Ghz, 18GB memory, 6x 15K SAS Raid 10 setup with Litespeed v4.0.20 for web, saving around ~348 cache hits/second or over 4 days has saved nearly 135 million hits to the MySQL database server! Notice memory utilisation is higher as besides vBulletin’s default datastore cache, the forums are also caching stylesheets/css and templates in Memcached cache servers by installing vB Optimise Pro plugin.
Approximately 12.75 hrs after last reading above on the 5th day, database hits saved amounts to 228+ million hits or ~509 cache hits/second average ! Nearly 94 million hits occured in last 12.75hrs, that’s ~2,046 cache hits/second since starting to cache vBulletin templates, stylesheets in addition to vBulletin datastore items. With 5.3+ million items in Memcached servers – that’s alot of vBulletin templates, stylesheets and datastore items!
Nearly 12hrs later, another 60.89 million cache hits made to 2x Memcached v1.4.5 servers which is nearly 1,440 cache hits/second in the past 12hrs! Overall, total 289.6+ million cache hits or around 589 cache hits/second over 5days 16hrs and 31minutes. That is alot of database query calls saved!
24hrs later an additional 126.7 million cache hits were made which is ~1,450 cache hits/second. This vB client’s vBulletin v4.1.2 forum has saved a total 416.3 million cache hits to the MySQL database server, that’s nearly 720 cache hits/second over 6 3/4 days!
