Bennett Haselton <[EMAIL PROTECTED]> wrote: > At 03:49 PM 8/25/2003 +0300, Egor Egorov wrote: >>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. >
If you execute LOCK TABLE, table will be locked, but SHOW PROCESSLIST will show NULL in the output for this thread. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
