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
8687
December 09, 2011 07:31AM
4190
December 10, 2011 04:11PM
2555
December 11, 2011 09:44AM
2617
December 13, 2011 05:38AM
1999
December 14, 2011 12:07PM
2293
December 15, 2011 08:13AM
2151
December 16, 2011 05:09PM
2224
December 25, 2011 01:35AM
1805
December 25, 2011 11:17PM
2006
December 26, 2011 05:40AM
1913
December 27, 2011 09:56AM
2008
January 05, 2012 12:57PM
1849
January 08, 2012 12:52PM
1723
January 26, 2012 05:27AM
1704
January 27, 2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert.
2207
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.