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.

High CPU Load

Discussion in 'Workarounds and Optimization' started by zmkhan90, Dec 17, 2014.

  1. zmkhan90

    zmkhan90 Registered

    Joined:
    Dec 17, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I am facing HIGH CPU Load on My SQL Server. I have checked the process list there is no such queries locked. But still its consuming 100% CPU. My Hardware Specs and DB Configuration are below.

    Note: I am using only MySQL on this server. And using MyISAM as DB Engine

    Code:
    Hardware Specs
    
    CPU : 2 x Intel Xeon E5-2630v2 (2.60 GHz, 6 cores, 12 threads, 15 MB cache) (DL380p Gen8 (2xE5-2630v2) 12-LFF)
    
    RAM : 64GB
    
    HDD : 1200GB SAS 15k rpm, 3.5 ms, Enterprise
    
    Code:
    DB Configuration :
    
    [mysqld]
    # GENERAL #
    user                           = mysql
    default-storage-engine         = InnoDB
    socket                         = /var/lib/mysql/mysql.sock
    pid-file                       = /var/lib/mysql/mysql.pid
    tmpdir			       = /tmp
    
    
    # MyISAM #
    key-buffer-size                = 64M
    myisam-sort-buffer-size         = 128M
    myisam-recover                 = FORCE,BACKUP
    
    # SAFETY #
    max-allowed-packet             = 16M
    max-connect-errors             = 1000000
    skip-locking
    skip-name-resolve
    # skip-networking
    
    # CACHES AND LIMITS #
    tmp-table-size                 = 32M
    max-heap-table-size            = 32M
    query-cache-type               = 0
    query-cache-size               = 0
    max-connections                = 20000
    thread-cache-size              = 50
    open-files-limit               = 65535
    table-definition-cache         = 4096
    table-open-cache               = 4096
    
    # INNODB #
    innodb-flush-log-at-trx-commit = 1
    innodb-file-per-table          = 1
    innodb-buffer-pool-size        = 26G
    
    # SLOW QUERY
    log-slow-queries = /var/log/mysql-slow.log
    long_query_time = 25
     
  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
Loading...

Share This Page