Need Help Regarding Mysql Urgently... (site loading very slow)

Discussion in 'MySQL' started by dxgamers, Aug 29, 2010.

0
  1. #1
    hey dude, i'm getting this error .
    plz help me dude.
    [​IMG]

    Friends, Plz tell me that which thing is causing this huge problem?
    1. Kloxo or Centos
    2. Mysql Problem
    3. Server Problem
    4. Os problem
    5. Any Other.
     
    dxgamers, Aug 29, 2010 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    MySQL Server does not have enough memory to process this query. Try running this query without ORDER BY RAND(). Are you on a dedicated server?
     
    mwasif, Aug 29, 2010 IP
  3. dxgamers

    dxgamers Active Member

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    56
    #3
    no i am on a vps
    plz help
     
    dxgamers, Aug 30, 2010 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Did you try running the query as I mention?
     
    mwasif, Aug 30, 2010 IP
  5. dxgamers

    dxgamers Active Member

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    56
    #5
    Yup and it helped me
    thnxxxxxxxx
     
    dxgamers, Jun 6, 2011 IP