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.

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:
    87
    Likes Received:
    2
    Trophy Points:
    8
    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:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page