Bennett Haselton <[EMAIL PROTECTED]> wrote:
>
> I found a way to do this before, but I didn't write down how I did it, so I
> don't remember it now. And I've searched http://www.mysql.com/doc/ in
> vain.
>
> What's the command to show all current locks on a database table?
>
There is no command to show locks on the table.
Ah, OK. I'm trying to think of what I must have seen earlier that made me think there was a command to do this.
I think I was thinking of the SHOW PROCESSLIST command, which shows a list of threads and indicates whether they are waiting for a lock. I must have looked at that output and figured that I knew what the locked tables were.
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org (425) 497 9002
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
