InnoDB - Check for a row lock

I searched entire MySQL doc for info about how to check if row (InnoDB) is
locked for write but
i didnt found anything.
Supose we have 2 transactions
1st transaction do
SELECT some_field FROM table_a FOR UPDATE;
2nd transaction wants do check if row is in lock for write before
it isues SELECT some_field FROM table_a FOR UPDATE;
How to check ?
SELECT .. FOR UPDATE - causes client app to hang, server waits as long as
first transaction issue commit command...

Artur

Artur,

you need to use innodb_lock_monitor:

http://dev.mysql.com/doc/refman/5.0/...b-monitor.html

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php


"Artur Baæ" <nospam_artur@ebasoft.com.pl> kirjoitti
viestissä:e1eags$f30$1@news.task.gda.pl...
>I searched entire MySQL doc for info about how to check if row (InnoDB) is
>locked for write but
> i didnt found anything.
> Supose we have 2 transactions
> 1st transaction do
> SELECT some_field FROM table_a FOR UPDATE;
> 2nd transaction wants do check if row is in lock for write before
> it isues SELECT some_field FROM table_a FOR UPDATE;
> How to check ?
> SELECT .. FOR UPDATE - causes client app to hang, server waits as long as
> first transaction issue commit command...
>
> Artur
>
>