mysql locking question

Investigating/researching mysql/myisam locking. trying to find a good example of how to set the lock in appA, and determine/detect the tbl lock in appB.

searching google, not seeing much, so i must be missing something.

i'm going to be writing a php app that demonstrates this process.

pointers/thoughts/thanks..

-tom

Answers


You should have a look at MySQLs GET_LOCK() function.

Follow this link to get more information: MySQL Documentation for GET_LOCK()

This looks like it could solve your problem.


MySQL's GET_LOCK function gets named user locks, which are an extra feature MySQL provides over and above anything to do with tables.

No tables are involved so it does not invoke the storage engine and has nothing to do with myisam. GET_LOCK is available on all supported mysql versions regardless of what engines are used.


Need Your Help

in iphone how to get Sqlite last insert row id?

iphone objective-c ios sqlite

I am making an application where i want to use update query?

Delete Even Number of Nodes in Linked List And Print in Reverse

java list reverse

What should be the logic followed for this scenario.