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, as is to be expected, in the manual under "show > > processlist": http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html > > > > The same page explains that you need to have the 'process' privilege > > to be able to see all processes. Maybe the used login doesn't have it > > and therefore you are not seeing all queries? > > > > I'm the only user that has access to this database. That would mean that > I should be able to see all queries belonging to me. 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. > If there are any other queries they belong to another database and > therefore wouldn't be relevant. Correct. > I'm not sure about this but it sounds right... Are you sure that > there is a query that locks the table? 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. Regards, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
