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

guptaji

• December 27, 2015 07:18

3 mysql process are running from long time and each process is eating 9.X% CPU.. how to solve it ?

• 

  24x7server

  • December 28, 2015 12:47

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

  0
• 

  cPanelMichael

  • December 28, 2015 15:09

  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.

  0
• 

  guptaji

  • December 29, 2015 06:00

  after a graceful reboot.. this is what i'm getting from last 3 hours..

  0
• 

  cPanelMichael

  • December 29, 2015 16:25

  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.

  0
• 

  Rakibur Rahman

  • July 26, 2016 18:42

  Hi, I have the same issue. Mysql consuming so much CPU resource. My result is below:
  [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 ~]#
  

  0
• 

  cPanelMichael

  • July 26, 2016 18:50

  That's normal output for the "ps aux|grep mysql" command. Please refer to the following forum thread if you want to optimize your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.