mysqld CPU and memory Usage too high- 867%

[chawkimatta]

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 ?

 

[cPanelMichael]

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]

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

 

[cPanelMichael]

Hello

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

Thank you.

 

[chawkimatta]

Awesome !