Too high cpu loads from MySQL

[elias9]

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]

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.

 

[24x7ss]

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.

 

[cPanelMichael]

Hello

You posted the MySQL process, but not the actual server load. How high was the server load?

Thank you.