mysqld CPU and memory Usage too high- 867%

chawkimatta

Registered
Mar 2, 2015
3
0
1
Byblos, Lebanon, Lebanon
cPanel Access Level
Root Administrator
Hello guys,
suddenly i got this command running on top of the processes list and taking all the server resources (CPU and Memory)
Code:
/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:
Code:
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 :
Code:
innodb_file_per_table=1
open_files_limit=8172
-----------------------------
Any idea from where to start ? what is that command coming from ?:confused:
 

cPanelMichael

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

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

Thank you.