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.
Subject
Views
Written By
Posted
8674
December 09, 2011 07:31AM
4186
December 10, 2011 04:11PM
2553
December 11, 2011 09:44AM
2615
December 13, 2011 05:38AM
1995
December 14, 2011 12:07PM
2290
December 15, 2011 08:13AM
2149
December 16, 2011 05:09PM
2220
December 25, 2011 01:35AM
1805
December 25, 2011 11:17PM
2003
December 26, 2011 05:40AM
1912
December 27, 2011 09:56AM
2003
January 05, 2012 12:57PM
1845
January 08, 2012 12:52PM
1720
January 26, 2012 05:27AM
1702
January 27, 2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert.
2202
March 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.