Just Upgraded to MYSQL 5.6 from 5.5

[gohighvoltage]

Just Upgraded to MYSQL 5.6 from 5.5

I am on a Hybrid Server with 4gig of memory.

This is my current my.cnf file:

[mysqldump]
max_allowed_packet=64M
quick
[myisamchk]
write_buffer_size=1M
read_buffer_size=1M
key_buffer_size=64M
sort_buffer_size=1M
[mysqlhotcopy]
interactive-timeout
[mysqld]
performance_schema=off
range_alloc_block_size=4096
innodb_io_capacity=200
innodb_data_file_path="ibdata1:10M:autoextend"
table_open_cache=4000
key_buffer_size=256M
bulk_insert_buffer_size=8M
query_cache_type=1
query_alloc_block_size=65536
thread_cache_size=256
group_concat_max_len=1024
max_connect_errors=100000
connect_timeout=10
innodb_log_files_in_group=2
local-infile=0
transaction_alloc_block_size=8192
net_buffer_length=16384
innodb_log_buffer_size=8M
long_query_time=1
wait_timeout=90
innodb_read_io_threads=2
read_buffer_size=256K
innodb_write_io_threads=2
max_heap_table_size=64M
max_connections=350
table_definition_cache=4000
tmp_table_size=64M
concurrent_insert=2
join_buffer_size=256K
innodb_file_per_table=1
innodb_additional_mem_pool_size=32M
slow_query_log=0
back_log=50
innodb_buffer_pool_size=8M
myisam_sort_buffer_size=64M
innodb_flush_log_at_trx_commit=2
max_length_for_sort_data=1024
transaction_prealloc_size=4096
query_prealloc_size=262144
sort_buffer_size=256K
max_write_lock_count=4
max_allowed_packet=64M
read_rnd_buffer_size=786432
myisam_max_sort_file_size=2048M
innodb_log_file_size=5M
open_files_limit=9234
innodb_thread_concurrency=4
interactive_timeout=60
innodb_open_files=1000
innodb_buffer_pool_instances=1
default-storage-engine=MyISAM
query_cache_size=80M
max_seeks_for_key=1000
query_cache_limit=512K
innodb_lock_wait_timeout=50
slow_query_log_file="/var/log/mysql/slowq.log"
[mysqld_safe]
open-files-limit=8192
nice=-5

I added performance_schema=off because it was using a lot more memory. My idle memory was around 950mb on 5.5 and then it was 1.4gb with 5.6 with performance_schema on. When I turned it off, memory went back down to normal.

- - - Updated - - -

Thank you in advance!

 

[cPanelMichael]

Hello

The following thread should help you to provide us with more MySQL statistics:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.