The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqld CPU and memory Usage too high- 867%

Discussion in 'Workarounds and Optimization' started by chawkimatta, Mar 2, 2015.

  1. chawkimatta

    chawkimatta Registered

    Joined:
    Mar 2, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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:
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. chawkimatta

    chawkimatta Registered

    Joined:
    Mar 2, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Byblos, Lebanon, Lebanon
    cPanel Access Level:
    Root Administrator
    thank you cPanelMichael will check the thread and let you know what i get ! :)
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. chawkimatta

    chawkimatta Registered

    Joined:
    Mar 2, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Byblos, Lebanon, Lebanon
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page