Urgent! MySQL began hitting 70+ CPU load
Before this happened, I restored a cPanel account and I'm not sure if this is what is causing it.
Current my.cnf
I have 16gb RAM available, 2 HDD in SW RAID1, E31230 cpu. --- FOLLOW UP --- I suspended the questionable account and MySQL CPU usage did not decrease. It's odd how this problem just appeared. Also, I changed swappiness value from 60 to 40.
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-locking
##skip-innodb
query_cache_limit=6M
query_cache_size=128M
tmp_table_size=256M
max_heap_table_size=256M
table_open_cache=2048
open_files_limit=100000
key_buffer_size=128M
sort_buffer_size=128M
read_buffer_size=128M
join_buffer_size=64M
query_cache_type=1
max_user_connections=500
max_connections=2000
interactive_timeout=300
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=256M
max_allowed_packet=16M
#record_buffer=1M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
#[mysql.server]
#user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
#[mysqldump]
#quick
#max_allowed_packet=16M
[mysql]
no-auto-rehash
[mysqlhotcopy]
interactive-timeoutI have 16gb RAM available, 2 HDD in SW RAID1, E31230 cpu. --- FOLLOW UP --- I suspended the questionable account and MySQL CPU usage did not decrease. It's odd how this problem just appeared. Also, I changed swappiness value from 60 to 40.
-
Hello :) You should let MySQL run for at least 24 hours and then run the MySQL tuner to get more user-feedback. The following thread is a good place to start: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you. 0
Please sign in to leave a comment.
Comments
1 comment