Am 26.02.2013 22:16, schrieb Zachary Stern:
> It's InnoDB but it's not just about the number of rows.
> 
> The data literally isn't there. It's like rows at the end are being
> dropped. We have a frontend that queries and shows the data, but it ends up
> missing results.
> 
> I've asked the devs to review the code to see if their  could be deletions
> anywhere, but according to them, there's nothing

smells like transactions with missing commits

the thread which started the transaction and inserted data
will see the data, only this thread, and without a commit
after close the connection the data are gone because this
is how transactions are supposed to work -> ACID

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to