Mysql issues with VPS

[simplyjesse]

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]

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]

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]

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.