ahiguti/HandlerSocket-Plugin-for-MySQL — Issue #68: why introduce mysql named lock in lock_tables_if function call
Author: swingbach
Created: 2011-12-08 09:43:42+00:00
State: open

when I execute this line in MySQL
select get_lock("handlersocket_wr",10);
and then to insert a new row using handlersocket,it fails and return a error message

i was wondering why introduce this user level lock in the function call lock_tables_if which do a named lock which cause all the write be completely serializable

i thought innodb and mysql can do all the lock things,why the user level lock is needed.