Long mysql querries like "sorting result"
 

Processes are being spawned because we have long mysql querries like "sorting result" it the "post" table and all the other database connections are "Locked"

Code:
kharkovforum# mysqladmin -uroot -p********* processlist | less
+--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 711764 | dimoks_db1 | localhost | dimoks_db1 | Query | 23 | Sorting result | SELECT post.postid
FROM post AS post

WHERE post.threadid = 138177
AND post.visible = 1 |
| 711819 | dimoks_db1 | localhost | dimoks_db1 | Query | 23 | Sorting result | SELECT post.postid
FROM post AS post

WHERE post.threadid = 114665
AND post.visible = 1 |
| 711858 | dimoks_db1 | localhost | dimoks_db1 | Query | 23 | Sending data | SELECT MIN(postid) AS postid
FROM post
WHERE threadid = 159509
AND visible = 1
AND dat |
| 711942 | root | localhost | | Query | 0 | | show processlist |
+--------+------------+-----------+------------+---------+------+----------------+-----------------------------
...

Code:
kharkovforum# mysqladmin -uroot -p******** processlist | less
+--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 712940 | dimoks_db1 | localhost | dimoks_db1 | Query | 34 | Sorting result | SELECT post.postid
FROM post AS post

WHERE post.threadid = 388337
AND post.visible = 1 |
| 713089 | dimoks_db1 | localhost | dimoks_db1 | Query | 28 | Sorting result | SELECT post.postid
FROM post AS post

WHERE post.threadid = 91548
AND post.visible = 1
|
| 713174 | dimoks_db1 | localhost | dimoks_db1 | Query | 26 | Sorting result | SELECT post.postid
FROM post AS post

WHERE post.threadid = 91699
AND post.visible = 1
|
| 713251 | root | localhost | | Query | 0 | | show processlist |
+--------+------------+-----------+------------+---------+------+----------------+--------------------
Please help :(