MySQL Forums
Forum List  »  Memory Storage Engine

Re: MEMORY table rows randomly disappear - help!
Posted by: jkoerber
Date: May 19, 2010 11:25AM

False alarm.

We later discovered (after a thorough search of our 1MM+ lines of code) a REPLACE statement was the culprit. It was acting on a non-distinct primary key that happened to be the same for everyone and so it in effect "deleted" each person's authenticated record by replacing it.

Boy is my face red...

Options: ReplyQuote

Written By
Re: MEMORY table rows randomly disappear - help!
May 19, 2010 11:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.