|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi, Recently my board is under some kind of attack which makes the iowait very high and the server is down because of highload. When i check mysql slow query logs, i found lot of these: PHP Code: # User@Host: xxxx[xxxxxxx] @ localhost [] # Query_time: 318 Lock_time: 259 Rows_sent: 10 Rows_examined: 46574 SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.usergroupid, user.displaygroupid FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(4,91,104,111,4,9,75,91,58,81,84,59,60,61,104,108,117) ORDER BY lastpost DESC LIMIT 0, 10; # User@Host: xxxxxxx[xxxxxxx] @ localhost [] # Query_time: 320 Lock_time: 261 Rows_sent: 10 Rows_examined: 46574 SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.usergroupid, user.displaygroupid FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(4,91,104,111,4,9,75,91,58,81,84,59,60,61,104,108,117) ORDER BY lastpost DESC LIMIT 0, 10; What page, what query is it? Would could be the possible cause for this? Thanks __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
vB crashes MySQL on one really* really long query. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 09-27-2009 08:10 PM |
vB crashes MySQL on one really* really long query. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 09-27-2009 07:50 PM |
[SQL Query] I would like to update user time | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-19-2009 10:10 PM |
Poll time version forum time query | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-11-2009 08:50 PM |