Trying to reduce CPU consumption

AGuyInFL

• January 31, 2018 18:55

I noticed that in System Health > Process Manager this command: /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/my.mysite.com.err --open-files-limit=16384 --pid-file=/var/lib/mysql/my.mysite.com.pid consumes 40-50% CPU and 2-3% memory. Can someone explain what this command is all about? Is there something in it I can disable to reduce the CPU consumption? Maybe the log_error? If I disable it via my.cnf what should I replace it with? log_error = ""?

• 

  24x7server

  • February 01, 2018 06:21

  Hi,

  /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/my.mysite.com.err --open-files-limit=16384 --pid-file=/var/lib/mysql/my.mysite.com.pid

  
  This is a MySQL command that runs in background when you start the MySQL service.. If you want to check the mysql usage/coonection, you can use the bellow command: # mysqladmin proc

  0
• 

  cPanelMichael

  • February 01, 2018 17:31

  Hello, As noted in the previous post, that process is your MySQL server. It's normal for it to run at all times when MySQL is started. There's a thread here for tuning your MySQL configuration to increase performance if that's what you are seeking: Thank you.

  0

Please sign in to leave a comment.