MySQL and Apache2 using 100% CPU (need help)

Discussion in 'Site & Server Administration' started by Hamid Farhan, Sep 11, 2012.

  1. #1
    I am hosting a game on VPS. currently game has very few members but even then my server get slow down and load average reaches 3.
    I have purchased VPS from VPS.net.

    here are my stats of cpus in my vps

    Total RAM installed in 2300MB

    below is SQl conf file my.cnf

    I need help, MySQL sometimes uses 150% of CPU which slow downs my server.
     
    Hamid Farhan, Sep 11, 2012 IP
  2. prandah

    prandah Active Member

    Messages:
    95
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #2
    try use mysqltuner
     
    prandah, Sep 16, 2012 IP
  3. samirj09

    samirj09 Well-Known Member

    Messages:
    335
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    125
    #3
    Also, run "mysqladmin processlist" ; When this issue is occurring to find out which queries and databases are causing the issue. From here, you will be able to see what needs to be optimized.
     
    samirj09, Sep 16, 2012 IP
  4. Hamid Farhan

    Hamid Farhan Active Member

    Messages:
    83
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    50
    #4
    thanks for your help.
    i already try mysqlturner, it shows everything is fine.
     
    Hamid Farhan, Sep 17, 2012 IP