Hi all, I have a problem with a table in the database. I created it a while ago (a month maby) and then everything worked fine. Now however, every time I query the table the query hangs and I don't know why. I understand that it's difficult to tell me what the problem is based on that little information. But could someone tell me where I should start looking? Can I give some more information about the table, query or database that would help tracing the problem?
My mysql version: Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) This is the table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); FOR_SALE has about 20 rows. These are the processes: mysql> SHOW PROCESSLIST; +---------+---------+-----------+---------+---------+------+-------------------+-------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+---------+-----------+---------+---------+------+-------------------+ -------------------------------+ | 5393322 | jacob | localhost | jacob | Query | 564 | Waiting for table | Select count(*) from FOR_SALE | | 5394177 | jacob | localhost | jacob | Query | 0 | NULL | SHOW PROCESSLIST | +---------+---------+-----------+---------+---------+------+-------------------+ -------------------------------+ 2 rows in set (0.00 sec) I've been using the mysql db for almost 2 years now and this thing has never happened before. Please help me finding the problem. Thanks, Jacob _________________________________________________________________ Chatta med vänner online, prova MSN Messenger: http://messenger.msn.se --------------------------------------------------------------------- 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
