Skip navigation links

MySQL Forums :: InnoDB :: "Lock wait timeout exceeded" time out on insert.


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
"Lock wait timeout exceeded" time out on insert. 6320 Nic Whale 12/09/2011 07:31AM
Re: "Lock wait timeout exceeded" time out on insert. 2975 Rick James 12/10/2011 04:11PM
Re: "Lock wait timeout exceeded" time out on insert. 1737 Nic Whale 12/11/2011 09:44AM
Re: "Lock wait timeout exceeded" time out on insert. 1811 Nic Whale 12/13/2011 05:38AM
Re: "Lock wait timeout exceeded" time out on insert. 1391 Rick James 12/14/2011 12:07PM
Re: "Lock wait timeout exceeded" time out on insert. 1575 Nic Whale 12/15/2011 08:13AM
Re: "Lock wait timeout exceeded" time out on insert. 1522 Rick James 12/16/2011 05:09PM
Re: "Lock wait timeout exceeded" time out on insert. 1491 Nic Whale 12/25/2011 01:35AM
Re: "Lock wait timeout exceeded" time out on insert. 1202 Rick James 12/25/2011 11:17PM
Re: "Lock wait timeout exceeded" time out on insert. 1355 Nic Whale 12/26/2011 05:40AM
Re: "Lock wait timeout exceeded" time out on insert. 1331 Rick James 12/27/2011 09:56AM
Re: "Lock wait timeout exceeded" time out on insert. 1255 Nic Whale 01/05/2012 12:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1195 Rick James 01/08/2012 12:52PM
Re: "Lock wait timeout exceeded" time out on insert. 1078 Nic Whale 01/26/2012 05:27AM
Re: "Lock wait timeout exceeded" time out on insert. 1161 Rick James 01/27/2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1483 Nic Whale 03/11/2012 01:17AM


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.