Re: how to show all locks on a table?
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]
Re: how to show all locks on a table?
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. -- 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]
Re: how to show all locks on a table?
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. -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]
Re: how to show all locks on a table?
At 10:33 AM 8/21/2003 -0700, Bennett Haselton wrote: [already posted to mailing.database.mysql newsgroup but not to list; sorry for cross-post] 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? Did I commit some unforgivable faux pas in asking this question? :) I didn't think it was very obscure (even *I* figured it out at one point :) but I didn't write down how I did it, and now I can't figure out how to do it again). Not complaining, since it's free, it's just that usually I've seen much harder questions get answered pretty fast... Did somebody send a reply, and I didn't get it (my Web server, and possibly my email, was down for part of that day)? Or is it not possible to show current locks on a table, and maybe I'm mis-remembering what I saw, when I thought I'd found a way to do it? -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]
how to show all locks on a table?
[already posted to mailing.database.mysql newsgroup but not to list; sorry for cross-post] 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? -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]