MySQL Forums
Forum List  »  InnoDB

Re: Mysql hangs once in 2 days with mysterious deadlock?
Posted by: Viacheslav Romanov
Date: October 12, 2014 09:30AM

Sorry for late reply, I thought I am subscribed to the topic, but I was not.

By transactions I meant complex transactions that might cause deadlocks.

In my case there's certain deadlock: mysql stops reading/writing to disk (almost, drop from normal 30-40 MBytes/sec to 10 Kbytes/sec).

And I don't understand how it might be with simple selects or updates.

I have file_per_table = OFF, but it should affect only performance as I understand.

Options: ReplyQuote




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.