Re: MySQL reports no errors on inserts and updates but takes no action

[Ingo Strüwing]

HI.

Please say which MySQL version you use.

I wonder how you check that it "writes nothing into the tables". You say that you sometimes "restart MySQL or sometimes just rebuild the indexes". Does this mean that the rows appear in the table after restart or repair? Or do you need to insert/update them again?

Is it possible that every such case happens due to a corrupted index? I would think so if you use a query that uses an index to find the rows after insert/update.

If your effects have to do with a index corruption, disabling concurrent inserts might help. Unless it degrades the performance too much for your application.

Regards,
Ingo