Increased querries in server????

Discussion in 'Databases' started by greatestmj, Mar 25, 2006.

0
  1. #1
    i have seen a sudden rise in the number of querries

    i use smf forum... and 2000 querries per second is reported by my forum

    OMG

    wt to do?
     
    greatestmj, Mar 25, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    First thing to do would be to figure out why... Go through your web logs for example. If you can't find it in your web logs, start logging SQL queries to get a sampling of the queries being run.
     
    digitalpoint, Mar 25, 2006 IP
  3. zlos

    zlos Peon

    Messages:
    6
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    What kind of traffic do you get? Unical Users / Page Impressions? How much queries averagely it takes to produce one page?

    Any robots visiting your page?
    All the software working properly? No hangs?
    Maybe you got listed on main page of cnn.com? ;)
     
    zlos, Mar 26, 2006 IP
  4. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #4
    Try a: show processlist. Is possible to have a locked database and querys to stay in queue without doing anything ... what Load average do you have on that server?

    Regards
     
    sacx13, Mar 30, 2006 IP