I am running mysql 5.5.43 and have many sleep processes. But the big issue is extreme CPU usage that oscillates from 50 to 75% or more
I give you my my.cnf file that i have currently. Can you kindly suggest me what are the right parameters for a server with 128 GB Ram?
I dont have #innodb-log-file-size = 128M activated as when i try mysql wont start may be i need to flush logs?
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
thread_concurrency = 8
query_cache_size = 128M
query_cache_limit = 128M
thread_cache_size = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_open_cache = 512
max_allowed_packet = 16M
key_buffer_size = 4840M
wait_timeout = 40
interactive_timeout = 40
max_connections = 300
long_query_time = 10
INNODB
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 2456M
innodb_flush_log_at_trx_commit = 2
#innodb-log-file-size = 128M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid