>
>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 sai
Hi.
Please do not write to me only, but also to the list.
On Sat, May 11, 2002 at 10:31:48PM +0200, [EMAIL PROTECTED] wrote:
[...]
> > That said, "waiting for table" does not indicate normal table locks.
> > That would be "locked". So something different is going on. And this
> > is explained, a
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 o
lease help!
/ Jacob
>From: "Jacob Nordgren" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Something is blocking a table in our db
>Date: Sat, 11 May 2002 12:08:19 +
>
>
>How can I check if there are any other query that locks my table?
>
>
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,
>
>S
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
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 w
