elias9

Member
Oct 30, 2014
14
0
1
cPanel Access Level
Root Administrator
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

Member
Oct 2, 2014
21
0
1
cPanel Access Level
Root Administrator
Hi,

You have to find out which account causing the high load..

Check mysql process using :

Code:
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

Well-Known Member
Sep 30, 2014
272
17
68
India
cPanel Access Level
Root Administrator
Twitter
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

Administrator
Staff member
Apr 11, 2011
47,904
2,220
463
Hello :)

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

Thank you.