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
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.