>innodb_buffer_pool_size 23G - > 32G
How much RAM?
On a dedicated database server, you may set innodb_buffer_pool_size up to 80% of the machine physical memory size. However, do not set it too large because competition for physical memory might cause paging in the operating system.
>Innodb_buffer_pool_read_requests | 319023645695
>Innodb_buffer_pool_reads | 1077791394
1077791394 /319023645695 * 100 = 0.3378, which is good
>max_connections 6500 -> 4000
Whats the output of:
SHOW GLOBAL STATUS LIKE 'MAX_USED%'
SHOW VARIABLES LIKE 'wait_time%';
>query_cache_type on -> off
good
>table_open_cache 2048 -> 4096
Whats the output of:
show global status like 'open%';
>sort_buffer_size 2M -> 256K
Ok, what's the output of:
show global status like 'sort_%';
>innodb_buffer_pool_instances 1 -> 8
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-buffer-pools.html
Can we see output of:
SHOW GLOBAL STATUS\G
Do you have slow query log enabled? what do you see in there?
mysqldumpslow -s c -t 10 /path/to/slow_query_log