Tag Info

New answers tagged

3

The simplest solution to this seems like it would be to use a named lock. http://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_get-lock IF GET_LOCK('my_arbitrary_lock_name',0) THEN ... DO RELEASE_LOCK('my_arbitrary_lock_name'); ELSE ... END IF; This pool of locks is independent of table locks, metadata locks, row locks, or ...



Top 50 recent answers are included