Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    6
    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:
    604
    Likes Received:
    45
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 SysSachin, Jan 23, 2016
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,590
    Likes Received:
    2,186
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Jan 25, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql usage high
  1. Tsuna

    High MySQL usage - how to troubleshoot?

    Tsuna, Jun 22, 2019, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    195
    Tsuna
    Jun 25, 2019
  2. Maning

    MYSQL high cpu usage issue

    Maning, Oct 13, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    1,251
    cPanelLauren
    Oct 19, 2018
  3. baowesome

    MySQL Very High CPU Usage issue

    baowesome, Apr 2, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    1,488
    cPanelMichael
    Apr 2, 2018
  4. Igor Z.

    MySQL CPU usage 100%

    Igor Z., Jul 12, 2019, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    144
    cPanelMichael
    Jul 15, 2019
  5. Samet Chan

    MySQL Disk Usage Quota issue

    Samet Chan, Aug 21, 2018, in forum: General Discussion
    Replies:
    8
    Views:
    943
    cPanelMichael
    Aug 24, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice