Select for update nowait doesn't work in MySQL 5x (innodb). Is there any function like NOWAIT in MySQL?
MySQL provides the ability to set application-specific locking using the GET_LOCK() function. You can check if the mutex has been taken by using the IS_FREE_LOCK() function.
You can refer this thread for detail: http://forums.mysql.com/read.php?22,45679,45679#msg-45679
Also, Non-blocking queries are not supported by MySQL:
When it comes to InnoDB,
I wrote about this before in the DBA StackExchange
Note what the MySQL Documentation said on this:
You best chance it to change innodb_lock_wait_timeout to your liking