Showing locks

[Michael Widenius]

>>>>> "Steve" == Steve Ruby <stever@stripped> writes:

Steve> Is there any way to show the locks that have been created in a mysql
Steve> session?

Steve> for example if I am running the standard mysql client and I do

Steve> lock tables a,b,c read

Steve> Can I at some point know a,b,c are locked. I don't think this exists,
Steve> but may I suggest something like

Steve> show locks [READ | WRITE]

Steve> to be considered 

Steve> Thanks
Steve> Steve

Hi!

For the moment, you can only get the lock information by doing:

'mysqladmin debug'

This will dump the lock information on the MySQL 'hostname'.err file.

(The output is mainly useful for debugging )

Regards,
Monty