منتدى استراحات زايد - Query took long time? What is the cause?

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