Here is the part of the processlist from when the server was full... | Id | User | Host | db | Command | Time | State | Info | +------+-------+-----------+--------------+---------+------+--------------+- ---------------------------------------------------------------------------- -------------------------+ | 751 | dummy | localhost | fatfreeradio | Query | 3902 | Sending data | select * from song_files where uri ='Good_Riddance-Trophy-64.mp3 ' | | 807 | dummy | localhost | fatfreeradio | Query | 3888 | Locked | update song_files set current_score = '64', total_votes = '11' where uri = 'Good_Riddance-Trophy-128 | | 809 | dummy | localhost | fatfreeradio | Query | 3875 | Locked | select * from song_files where rec_num = '77' | | 811 | dummy | localhost | fatfreeradio | Query | 3870 | Locked | select * from song_files where uri ='Enemy_You-Lock_out-24.mp3 The rest of the list is just SELECTs. So, does that mean the first select got a lock, somehow got hung up talking to the server and never released the lock? What can I do to further diagnose this problem? Hunter --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
