Long mysql querries like "sorting result"

محروم.كوم · #1 11-10-2009, 10:50 PM

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 __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
""""""""مطلوب لكزس lx570 الدفع كاااش """"""""""	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-19-2010 03:50 AM
"""""""""""""""""""""""""""فساتين زفاف راقية ومميزة """"""""""&am	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-13-2010 12:00 AM
CMS Sorting Articles in CMS Home Page "Section wise"	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-15-2010 05:00 PM
Last 5.0 Mysql verion improves "bulk Insert" permance of Mysql. Useful for vb?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	10-05-2009 07:50 AM
"""""للبيع باترول سوبر سفاري موديل 99 ديزل """""""""	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-28-2009 02:40 PM