I have a database called TracerLock. Right now it is in some kind of state
where queries involving the "user" table will hang:
SELECT count(*) FROM user;
but queries involving any other table run fine:
mysql> select count(*) from news_article;
+----------+
| count(*) |
+----------+
| 1335037 |
+----------+
1 row in set (0.00 sec)
The /var/lib/mysql/tracerlock/ directory is where the user.MYD, user.MYI
and user.frm files are stored, but I don't see a lock file or anything in
there.
I just rebooted the server and now I can run queries on the user table just
fine. What general kind of event would cause all future queries on one
particular table to hang, without blocking queries on other types of
tables? (I'm guessing that next time I'll be able to unlock the table just
by stopping and restarting mysql instead of doing a full reboot.)
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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
