Bug #58498 timeout mechanism for LOCK TABLES statement

• Submitted: 25 Nov 2010 15:41
• Modified: 25 Nov 2010 15:55
• Reporter: Matthew Lord
• Status: Closed
• Category: MySQL Server: Locking
• Severity: S4 (Feature request)
• Version: all
• OS: Any
• CPU Architecture: Any

[25 Nov 2010 15:41] Matthew Lord

Description:
It would be nice if we had a table lock wait timeout.  You can accidentally cause an table to become exclusively locked for a long period of them if you run ALTER TABLE, for example, while there is a very long SELECT statement running on that table.  It would be very nice if this could be timed out.

How to repeat:
N/A

Suggested fix:
N/A

[25 Nov 2010 15:55] Matthew Lord

already done in 5.5:
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lock_wait_timeo...