http://www.tonyspencer.com/2008/10/23/if-you-get-this-in-mysql-lock-wait-timeout-exceeded-try-restarting-transaction/ It's Just Links Wed, 14 Sep 2011 13:47:04 +0000 http://wordpress.org/?v=2.9.1 hourly 1 http://www.tonyspencer.com/2008/10/23/if-you-get-this-in-mysql-lock-wait-timeout-exceeded-try-restarting-transaction/comment-page-1/#comment-168388 Haravikk Tue, 26 May 2009 22:53:33 +0000 http://www.tonyspencer.com/2008/10/23/if-you-get-this-in-mysql-lock-wait-timeout-exceeded-try-restarting-transaction/#comment-168388 Wouldn't you be better served by reducing the query to several small ones using LIMIT? The timeout is there to stop people from flooding your database with huge queries. Wouldn’t you be better served by reducing the query to several small ones using LIMIT? The timeout is there to stop people from flooding your database with huge queries.

]]> http://www.tonyspencer.com/2008/10/23/if-you-get-this-in-mysql-lock-wait-timeout-exceeded-try-restarting-transaction/comment-page-1/#comment-136523 Zack Sun, 21 Dec 2008 20:27:46 +0000 http://www.tonyspencer.com/2008/10/23/if-you-get-this-in-mysql-lock-wait-timeout-exceeded-try-restarting-transaction/#comment-136523 Hey thanks for the setting info. I have a lot of long transactions so I will be keeping it at about 100 seconds which shouldnt be an issue on my production server. Hey thanks for the setting info. I have a lot of long transactions so I will be keeping it at about 100 seconds which shouldnt be an issue on my production server.

]]>