Last time we looked at SKIP
LOCKED where rows locked by another process were
skipped. NOWAIT informs the server to return immediately
IF the desired rows can not be locked.
How To Use NOWAIT Start a connection to your MySQL 8 server,
start a transaction, and make a query to lock up part of the
data. mysql>START TRANSACTION; mysql>SELECT *
FROM city WHERE countryCode = 'USA' FOR UPDATE;
On a second connection, start a transaction and issue a SELECT
query with NOWAIT. mysql>START TRANSACTION;
mysql>SELECT * FROM city WHERE countryCode = 'USA' FOR
UPDATE NOWAIT;
The second connection will get a message saying 'statement
aborted because lock(s) could not be acquired immediately and
NOWAIT is SET
So if you can come back later to lock the records or just can not …
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 1 of 1
« Previous |
Next »
Nov
07
2017