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: '[EMAIL PROTECTED] ' Sent: 5/25/04 2:56 PM Subject: RE: DB hanging V == [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
