Re: Minimal example of using select… for update to isolate rows

[Rick James]

Use 2 transactions, not one:
BEGIN;
$id = SELECT id ... FOR UPDATE;
UPDATE x='dirty' ... WHERE id = $id;
COMMIT; -- Release fast!!
Then...
BEGIN;
do your work with $id -- this can take a long time
UPDATE x='free' ... WHERE id = $id;
COMMIT;