← Back to team overview

ourdelta-developers team mailing list archive

[Bug 301167] Re: Check out the WaffleGrid patch (InnoDB, Memcached)

 

This patch needs two more things to be production ready.

The memcached server specification needs to be a configvar instead of
compiled in.

The memcache key needs to have a unique-per-run id encoded into it, so
that when mysqld is restarted without restarting the memcached servers,
it doesnt try to pick up stale cached data, and get corrupted.


It would be good to insert the block id's being cached into a bloom filter.  That way it can check the bloom filter before checking the memcached, and thus the cost of cache misses will go way down.

A nice-to-have would be to add cache hit and cache miss counters, and
display them as statistics.

-- 
Check out the WaffleGrid patch (InnoDB,Memcached)
https://bugs.launchpad.net/bugs/301167
You received this bug notification because you are a member of OurDelta-
developers, which is the registrant for OurDelta.

Status in OurDelta - Builds for MySQL: New

Bug description:
Memcached as a L2 Cache for Innodb - The Waffle Grid Project

See http://www.bigdbahead.com/?p=73



References