Database damaged need help

Discussion in 'MySQL' started by saqistation, Nov 12, 2009.

  1. #1
    hi
    my vbulletin database get damaged while migrating vps. now it isn't giving any error. but when board get a few more users it start eating all ram (including swap).
     
    saqistation, Nov 12, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    There might be a problem with VPS setup or may be some indexes have been deleted.
     
    mwasif, Nov 12, 2009 IP
  3. saqistation

    saqistation Peon

    Messages:
    328
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    can you please enplane it?
     
    saqistation, Nov 12, 2009 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    That was just a thought. In the absebse of indexes, it is possible that MySQL eating up more resouce when its usage increased. It is better to enable slow query log and check table indexes involved in those reported slow queries.
     
    mwasif, Nov 12, 2009 IP