SEO

#1 (**permalink**) 02-28-2008, 10:29 AM

Using "show open tables" I see some tables locked. But I cant find
the locking process. When using "show processlist" I cant get any hint
which of the processes holds the lock (or is waitiing for the lock).

How can I get the process-IDs of th processen holding (and waiting)
for a lock?

chears
Silvio

#2 (**permalink**) 02-28-2008, 10:29 AM

>Using "show open tables" I see some tables locked. But I cant find
>the locking process. When using "show processlist" I cant get any hint
>which of the processes holds the lock (or is waitiing for the lock).
>
>How can I get the process-IDs of th processen holding (and waiting)
>for a lock?

That's probably the process ID of the MySQL server process for all
of them.

Assuming you want client process IDs, that might not be meaningful
since the client process might be running on a remote system.

What *would* be meaningful would be to get the connection ID of the
MySQL connection (so the MySQL "kill" command could be used with
it) holding the lock. I don't know of a way to get that, though.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Finding locking process