> >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 opposite of that. Did you actually read the page I >sugested? The manual explains, IIRC, that this status appears if >somehow the table structure changed (e.g. ALTER TABLE), and the >current query waits that all other tasks finish using the table. > >So there should be some query blocking the table in question. Yes I've read it. However I haven't changed the table structure, not from the promt and not from any script. Shouldn't I be able to see any query that me/my script has generated? Even if it is an ALTER TABLE query? Thank you for your help, Jacob _________________________________________________________________ Skicka och ta emot Hotmail-meddelanden på din mobilenhet: http://mobile.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
