How big is this table?
Do you run maintenance on this table?
What does the show index for this table look like?
-----Original Message-----
From: Brandon Metcalf
To: Victor Pendleton
Cc: 'mysql@stripped '
Sent: 5/25/04 2:56 PM
Subject: RE: DB hanging
V == VPendleton@stripped writes:
V> What does show processlist return when this is happening? Is
anything being
V> logged to the error log?
Nothing in the error log, but here's the output from show processlist:
mysql> show processlist;
+-----+--------------+------------------------+----------------+--------
-+------+--------+------------------------------------------------------
------------------------------------------------+
| Id | User | Host | db |
Command | Time
| State |
Info
|
+-----+--------------+------------------------+----------------+--------
-+------+--------+------------------------------------------------------
------------------------------------------------+
| 255 | submit_write | myhost.our.domain | submit_cheetah | Query
| 857
| Locked | UPDATE sub SET
Status=4,RevKey=1,SubDate='2004-05-25',SubTime='11:48:54' WHERE
SubNum=7529 |
| 257 | submit_write | myhost2.our.domain | submit_cheetah | Query
| 845
| Locked | SELECT status,litetag FROM sub WHERE
subnum=7531 |
| 258 | submit_write | myhost3.our.domain | submit_cheetah | Query
| 731
| Locked | INSERT INTO sub SET SubNum=0, Status=0, RevKey=1,
Creator='xxxxx',
LiteTag=NULL, CrDate='2004-05- |
| 259 | submit_write | myhost3.our.domain | submit_cheetah | Query
| 682
| Locked | INSERT INTO sub SET SubNum=0, Status=0, RevKey=1,
Creator='xxxxx',
LiteTag=NULL, CrDate='2004-05- |
| 264 | submit_write | myhost3.our.domain | submit_cheetah | Query
| 472
| Locked | INSERT INTO sub SET SubNum=0, Status=0, RevKey=1,
Creator='xxxxx',
LiteTag=NULL, CrDate='2004-05- |
| 265 | submit_write | myhost4.our.domain | submit_cheetah | Query |
324
| Locked | SELECT status,litetag FROM sub WHERE
subnum=7491 |
| 280 | submit_write | myhost5.our.domain | submit_cheetah | Query
| 0
| NULL | show
processlist
|
+-----+--------------+------------------------+----------------+--------
-+------+--------+------------------------------------------------------
------------------------------------------------+
7 rows in set (0.01 sec)
--
Brandon
