|
I’m been reading up on FOR UPDATE NOWAIT
and it looks like it was added in 8.1. How difficult is it to add FOR UPDATE SKIP LOCKED or
something similar? (basically skip locked rows / oracle syntax) More background here: http://forge.mysql.com/worklog/task.php?id=3597 It would be quite useful to implement a database queue.
Although FOR UPDATE NOWAIT and trying again can work as well as other
techniques, just skipping over the locks has its advantages (simplicity
and zero wait) |
