MySQL not responding, Writing to net status
Your problem is quite straightforward.


You mentioned that the table is using the MyISAM storage engine.
The processlist shows


Process ID 3629079 is running SELECT * FROM web.files order by file_name_eng desc
SELECT has been running 2324 seconds (39 min 44 sec)
Process ID 3649490 is running UPDATE query
SELECT has blocking the UPDATE for 1967 sec (32 min 47 sec)



NOTE : Any INSERT, UPDATE, DELETE on a MyISAM table requires a full table lock each time.

NOTE : If a series of 50 UPDATEs is issued on one table, each UPDATE requires a full table lock.

SUGGESTION #1

If web.files has no FULLTEXT indexes, you should convert web.files to InnoDB with

ALTER TABLE web.files ENGINE=InnoDB;


I suggested this because InnoDB will allow UPDATEs, DELETEs, and INSERTs to harmoniously coexist with SELECTs via MVCC and Transaction Isolation.

If you are not the Project Manager/Lead Developer, please consult with your Project Manager/Lead Developer before doing this.

SUGGESTION #2

SELECT * FROM web.files order by file_name_eng desc


From the EXPLAIN plan, I can see that the query


Query must do a full table scan because there is no WHERE clause
There is no index on file_name_eng column, so there is no assistance in order the table (a filesort would happen, but happen fast)


Therefore, you should run

ALTER TABLE web.files ADD INDEX (file_name_eng);


Rhetorial Questions


Do you need SELECT * ?
Could you list only the columns you really need ?