High CPU Load

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

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

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

cPanelMichael

December 17, 2014 15:34

Hello :) You can run a MySQL tuning application and provide the results here for user-feedback. Information on this is available at: mysqlmymonlite.sh server stats gathering tool for cPanel Server Ensure you let MySQL run for at least 24 hours before running the tuner to ensure accurate results. Thank you.

High CPU Load

Comments

Didn't find what you were looking for?