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: ''mysql@stripped ' '
Sent: 5/25/04 3:35 PM
Subject: RE: DB hanging
V == VPendleton@stripped 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
