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: [application/pgp-signature] OpenPGP digital signature signature.asc