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

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,241
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,241
363
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.
 

Rakibur Rahman

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

Code:
[[email protected] ~]# 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
[[email protected] ~]#