Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Urgent! MySQL began hitting 70+ CPU load

Discussion in 'Workarounds and Optimization' started by iso99, May 30, 2014.

  1. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    107
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Before this happened, I restored a cPanel account and I'm not sure if this is what is causing it.

    Current my.cnf
    Code:
    [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.
     
    #1 iso99, May 30, 2014
    Last edited: May 30, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,633
    Likes Received:
    1,787
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice