If you want to check a table while the database is being used I suggest using mysqlcheck instead of myisamchk. The table is `relatively small. I would suggest running an optimize table or an analyze table to reestablish the cardinality.
-----Original Message----- From: Brandon Metcalf To: Victor Pendleton Cc: ''[EMAIL PROTECTED] ' ' Sent: 5/25/04 3:35 PM Subject: RE: DB hanging V == [EMAIL PROTECTED] writes: V> How big is this table? It has 7325 rows. V> Do you run maintenance on this table? Not regularly. I just ran myisamchk against it and here's what I got. I'm not sure if this is useful since there are current connections: Checking MyISAM file: /home/cmvobadm/tmp/cheetah/sub Data records: 7325 Deleted blocks: 0 ./myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 MyISAM-table '/home/cmvobadm/tmp/cheetah/sub' is usable but should be fixed V> What does the show index for this table look like? mysql> show index from sub; +-------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+---------+ | sub | 0 | PRIMARY | 1 | SubNum | A | 7325 | NULL | NULL | | | sub | 1 | RevKey | 1 | RevKey | A | 1046 | NULL | NULL | | +-------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+---------+ 2 rows in set (0.00 sec) -- Brandon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
