Urgent! MySQL began hitting 70+ CPU load

iso99

• May 30, 2014 03:48

Before this happened, I restored a cPanel account and I'm not sure if this is what is causing it. Current my.cnf [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-timeout
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.

• 

  cPanelMichael

  • May 30, 2014 13:34

  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.