Bug #6150 | Incremental LOCKs or stacked LOCKs | ||
---|---|---|---|
Submitted: | 18 Oct 2004 23:25 | Modified: | 3 Oct 2008 16:40 |
Reporter: | Levap Aretnyd | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | Heikki Tuuri | CPU Architecture: | Any |
[18 Oct 2004 23:25]
Levap Aretnyd
[19 Oct 2004 12:26]
Heikki Tuuri
Hi! MySQL's table lock code does not have deadlock detection. Therefore, you cannot 'incrementally' lock tables. We have in our TODO to implement LOCK TABLE TRANSACTIONAL ... that will allow 'incremental' locking. We plan to have the feature available in InnoDB in 2005. Regards, Heikki
[3 Oct 2008 16:40]
Konstantin Osipov
http://forge.mysql.com/worklog/task.php?id=3561 "LOCK TABLES transactional"