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
