The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Just Upgraded to MYSQL 5.6 from 5.5

Discussion in 'Workarounds and Optimization' started by gohighvoltage, Feb 27, 2014.

  1. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    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:

    Code:
    [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!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page