MySQL Forums :: InnoDB :: Innodb configuration optimal for my workload?

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.