MySQL Forums :: InnoDB :: "Lock wait timeout exceeded" time out on insert.
Re: "Lock wait timeout exceeded" time out on insert.
Posted by: Nic Whale ()
Date: March 11, 2012 01:17AM
Hi Rick,
After a lot of thought and investigation I am considering enabling innodb_locks_unsafe_for_binlog, "set innodb_locks_unsafe_for_binlog=1".
This is said to reduce locks in MySQL Innodb V5.1. I know there is a chance of phantom records, but the way our system is built this is unlikely to be an issue.
Obviously this is an all or nothing solution.....
Thoughts?
Nick
Edited 1 time(s). Last edit at 03/11/2012 01:19AM by Nic Whale.
After a lot of thought and investigation I am considering enabling innodb_locks_unsafe_for_binlog, "set innodb_locks_unsafe_for_binlog=1".
This is said to reduce locks in MySQL Innodb V5.1. I know there is a chance of phantom records, but the way our system is built this is unlikely to be an issue.
Obviously this is an all or nothing solution.....
Thoughts?
Nick
Edited 1 time(s). Last edit at 03/11/2012 01:19AM by Nic Whale.
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.
© 2013, Oracle Corporation and/or its affiliates