The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql cpu usage high, and crashes vps

Discussion in 'Workarounds and Optimization' started by nhadsall, Jan 22, 2016.

  1. nhadsall

    nhadsall Member

    Joined:
    Nov 7, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    San Antonio, TX
    cPanel Access Level:
    Root Administrator
    Hello,
    I have a smaller VPS. So far things have been fine. I host a dozen low traffic sites. I just brought on one more site (again, fairly low traffic). Now mysql usage got so high that no other site could connect to the DB. I had to restart the VPS twice. Any suggestions about how to go about tracking down the problem?

    Thank you!
     
    #1 nhadsall, Jan 22, 2016
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    542
    Likes Received:
    39
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    You can check the Mysql process using below command so that you will get idea which database process causing high load on the server

    mysqladmin proc
     
    #2 SysSachin, Jan 23, 2016
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, as mentioned, use the "mysqladmin processlist" command when MySQL usage is high to see if you can get a better idea about which databases are the culprit. Also, you may find this thread helpful:

    Troubleshooting high server loads on Linux servers

    Thank you.
     
    #3 cPanelMichael, Jan 25, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql usage high
  1. janipewter

    MySQL constant high CPU usage

    janipewter, Feb 8, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    619
    cPanelMichael
    Feb 10, 2017
  2. urkeee

    Help - optimize mysqltunner to reduce high cpu usage

    urkeee, Nov 14, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    1,022
    cPanelMichael
    Nov 16, 2016
  3. wesley700r

    MySQL database high CPU usage

    wesley700r, Aug 18, 2016, in forum: Database Discussions
    Replies:
    2
    Views:
    609
    cPanelMichael
    Aug 23, 2016
  4. Ahmed Hany

    mysql high cpu usage issue

    Ahmed Hany, May 5, 2016, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    1,255
    Znuff
    May 17, 2016
  5. jjtt

    MySQL Extremely High CPU Usage

    jjtt, Apr 1, 2016, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    1,773
    cPanelMichael
    Apr 4, 2016

Share This Page