A few weeks ago I posted a message about tables corrupting every two days or
so. We have one process on each of two machines that run about 2 INSERT or
REPLACE statements per second. We recently modified the code performing
these INSERTs so that instead of keeping one connection to MySQL open, we
open and close a connection to MySQL for each INSERT. Since we made this
change our table has yet to become corrupted (+1 week now).
I don't know what this means...I just thought I should share that with
anyone who was having a similar problem.
Jay Miller
Socket Internet Services
Columbia, MO, US

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.