Announcement

Collapse
No announcement yet.

Query took long time? What is the cause?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:
    [email protected]: xxxx[xxxxxxx] @ localhost []
    # Query_time: 318  Lock_time: 259  Rows_sent: 10  Rows_examined: 46574
    SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycountthread.lastposterthread.datelinethread.viewsthread.visiblethread.openuser.usernameuser.useriduser.usergroupiduser.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;
    [email protected]: xxxxxxx[xxxxxxx] @ localhost []
    # Query_time: 320  Lock_time: 261  Rows_sent: 10  Rows_examined: 46574
    SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycountthread.lastposterthread.datelinethread.viewsthread.visiblethread.openuser.usernameuser.useriduser.usergroupiduser.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
    1 Stop Anonymous

    Search for "lauxanh" in Google and see if what comes up pleased you

  • #2
    Hello,

    Does anyone have any idea?

    Thanks
    1 Stop Anonymous

    Search for "lauxanh" in Google and see if what comes up pleased you

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X