> Can you give more info about exactly what the app is doing? Something like this:
value = memcache.get("record" + x)
if (false == value && cache.add("lock" + x, "1", 60)) {
compute (expensive) record
insert record with Primary key x Into DB
memcache.set("record" + x, record);
memcache.delete("lock" + x);
} else {
// someone else is doing the expensive stuff
}
In a very few cases (<20 of 3 Million) we observed a "Duplicate entry"
Mysql-Error.
