Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it releases the lock... I've tried with Multi Level Transactions, but BEGIN TRANSACTION release lock... I've tried whith SAVEPOINT, but it isn't possible to COMMIT TO a SAVEPOINT...
Anyone have solution(s) ? Thanks.
Best regards Jacky
|