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.

--log-error/var/lib/mysql/localhost.localdomain.err --open-files-limit10000

Discussion in 'General Discussion' started by guptaji, Dec 27, 2015.

  1. guptaji

    guptaji Active Member

    Joined:
    Sep 8, 2014
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    3 mysql process are running from long time and each process is eating 9.X% CPU..

    how to solve it ?
     

    Attached Files:

  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you please try to restart mysql services on your server and check if you are facing same issues with the mysql.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can run a command such as "ps aux|grep mysql" via SSH to verify if these processes are actually running after restarting MySQL.

    Thank you.
     
  4. guptaji

    guptaji Active Member

    Joined:
    Sep 8, 2014
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    after a graceful reboot.. this is what i'm getting from last 3 hours..
     

    Attached Files:

  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    That shows only one MySQL process. Please run the command referenced in my last response if you notice the issue is still occurring.

    Thank you.
     
  6. Rakibur Rahman

    Rakibur Rahman Registered

    Joined:
    Feb 26, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Jessore, Bangladesh
    cPanel Access Level:
    Root Administrator
    Hi, I have the same issue. Mysql consuming so much CPU resource. My result is below:

    Code:
    [root@secure ~]# ps aux|grep mysql
    mysql     460101  0.0  0.0 113252  1628 ?        Ss   00:39   0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
    mysql     460221 78.2  1.1 3492556 373868 ?      Sl   00:39   0:50 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/secure.domain.comerr --open-files-limit=60000 --pid-file=secure.domain.com.pid
    root      461445  0.0  0.0 112648   972 pts/0    S+   00:40   0:00 grep --color=auto mysql
    [root@secure ~]#
    
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page