MySQL Forums
Forum List  »  InnoDB

Re: Innodb configuration optimal for my workload?
Posted by: Greg Kemnitz
Date: October 04, 2011 12:10PM

you could be getting deadlocks if there's a lot of recs for the "tracomex" account id - or if the table is relatively small and the secondary index isn't used. We noticed that innodb appears to write-lock all the recs in the table if a table scan is used to process an update's where clause, which it may be if the table is small, and this can cause occasional deadlocks.

Options: ReplyQuote

Written By
Re: Innodb configuration optimal for my workload?
October 04, 2011 12:10PM

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.