Long mysql querries like "sorting result"

[Dimoks]

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"

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                                                                                     |
+--------+------------+-----------+------------+---------+------+----------------+-----------------------------

...

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

[Trevor Hannant]

Might be worth posting this in the Server Configuration forum as there's a few guys in there regularly who might not see it here...