Too high cpu loads from MySQL

elias9

• October 02, 2015 14:07

Very load: /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql//pluto.xxxxxx.com.err --open-files-limit=14000 --pid-file=/var/lib/mysql/best.xxxxxx.com.pid --socket=/var/lib/mysql/mysql.sock how is resolve this? my vps have 8 gb in ram and 4 cpu; Mysql version is 5.5

• 

  lx24

  • October 03, 2015 11:34

  Hi, You have to find out which account causing the high load.. Check mysql process using :
  mysqladmin pr
  See the processes of user and then check what is going on under such account. You may also need to check access-logs for that account. Also optimize your mysql server. You will find many post around the cpanel for the same.

  0
• 

  24x7ss

  • October 05, 2015 17:25

  Can you provide you /etc/my.cnf output. It seems that mysql is not properly optimized as there is enough RAM available. You can use mysqltunner script to optimize mysql.

  0
• 

  cPanelMichael

  • October 05, 2015 23:43

  Hello :) You posted the MySQL process, but not the actual server load. How high was the server load? Thank you.

  0

Please sign in to leave a comment.