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 issues with VPS

Discussion in 'General Discussion' started by simplyjesse, Feb 24, 2014.

  1. simplyjesse

    simplyjesse Member

    Joined:
    Feb 24, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. simplyjesse

    simplyjesse Member

    Joined:
    Feb 24, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    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!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page