Just Upgraded to MYSQL 5.6 from 5.5

gohighvoltage

• February 27, 2014 09:52

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. [COLOR="silver">- - - Updated - - - Thank you in advance!

• 

  cPanelMichael

  • February 27, 2014 14:55

  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.

  0

Please sign in to leave a comment.