mysqld CPU and memory Usage too high- 867%

Hello guys, suddenly i got this command running on top of the processes list and taking all the server resources (CPU and Memory)

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ip-[SERVER_IP].ip.secureserver.net.err --open-files-limit=8172 --pid-file=/var/lib/mysql/ip-[SERVER_IP].ip.secureserver.net.pid

Any idea from where to start ? what is that command coming from ? tried to add the following to etc/my.cnf but mysql is not starting:

skip-name-resolve
myisam_use_mmap=1

max_connections=100
max_user_connections = 50

safe-show-database

query_cache_type = 1
query_cache_size = 75M
query_cache_limit = 2M

join_buffer_size=1M
read_rnd_buffer_size=1M
max_allowed_packet = 10M

tmp_table_size=25M
max_heap_table_size=25M

table_open_cache = 7500
thread_cache_size = 25

open_files_limit=30000

key_buffer_size = 500M
myisam_sort_buffer_size = 256M

innodb_file_per_table=1
innodb_buffer_pool_size = 1G
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M

----------------------------- now i have those lines only :

innodb_file_per_table=1
open_files_limit=8172

----------------------------- Any idea from where to start ? what is that command coming from ?:confused:

cPanelMichael

March 03, 2015 12:41

Hello :) The following thread is useful if you want to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

chawkimatta

March 03, 2015 13:44

thank you cPanelMichael will check the thread and let you know what i get ! :)

March 03, 2015 13:59

Hello :) I've also moved this thread to our "Optimization" forum, where you should receive more relevant user-feedback. Thank you.

March 04, 2015 09:26

Awesome !:)

mysqld CPU and memory Usage too high- 867%

Comments

Didn't find what you were looking for?