simplyjesse

Member
Feb 24, 2014
7
0
1
cPanel Access Level
Website Owner
I am having some issue with my VPS potentially as I had to have the mysql service restarted and was wondering if it had to do with this process within my process manager:

Owner = mysql
CPU% = 74.4
Memory usage = 0.3
Command = /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/ip-serveriphere.ip.secureserver.net.err --open-files-limit=4142 --pid-file=/var/lib/mysql/ip-serveriphere.ip.secureserver.net.pid


Does anyone know what this issue is from or if it is an issue at all and how can I fix it?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

That is just the standard MySQL process. Check your MySQL error log (/var/lib/mysql/$hostname.err) if your MySQL service continues to fail and look for any specific error messages.

Thank you.
 

simplyjesse

Member
Feb 24, 2014
7
0
1
cPanel Access Level
Website Owner
Is that a high CPU% though on a vps that has 8 cpu? Thanks for the quick reply and warm welcome :) Just found this forum looks real helpful!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
It's not necessarily a problem, but there are several other factors to consider. The following thread might help you:

Troubleshooting High Load On Linux Systems

Also, feel free to post in our "Optimization" forum if you would like to seek help optimizing your MySQL performance through the configuration file.

Thank you.