Are all queries relevant to the table running as you? E.g. with
dynamic web pages (CGI, PHP, ...) that is most often not the case.
I'm not sure what you mean by 'relevant to the table' but since I've created
all the dynamic pages I'm absolute sure of what queries there are.
Huh? I said the
Hi,
Something is blocking our table (BOOKS) in a database that we don't have
administrative rights to. (we rent from Hurricane Electric, www.he.net).
Everytime we query the table it gets in the processlist with the state
Waiting for table. We've killed every process in the processlist but we
Hi again,
This is our MySQL version:
maple:~$ mysql --version
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
/ Jacob
From: Jacob Nordgren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Something is blocking a table in our db
Date: Sat, 11 May 2002 08:40:18 +
Hi,
Something
How can I check if there are any other query that locks my table?
/ Jacob
From: Jacob Nordgren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Something is blocking a table in our db
Date: Sat, 11 May 2002 08:40:18 +
Hi,
Something is blocking our table (BOOKS) in a database that we
One of our table is locked and there is not a process in the processlist.
How can I find out why? I want to start use the table again. Our website is
down! I've tried to flush the table but I don't have enough priveliges to
execute that command...
Any ideas are appreciated!!!
Please help!
Hello.
Posting in 2 hour intervals is a perfect way of getting ignored on the
list. This is a list of volunteers. If you require a quick answer,
consider buying support.
That said, waiting for table does not indicate normal table locks.
That would be locked. So something different is going on.