List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 8 1999 2:01am
Subject:Showing locks
View as plain text  
>>>>> "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


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 )


Showing locksSteve Ruby7 Oct
  • Showing locksMichael Widenius8 Oct