[client]
    default-character-set         = utf8mb4
    port                          = PORT
    socket                        = /srv/myPORT/run/mysql.sock

    [mysqld]
    user                          = mysql
    port                          = PORT
    extra-port                    = 1PORT
    character_set_server          = utf8mb4
    server_id                     = SERVER_ID
    socket                        = /srv/myPORT/run/mysql.sock
    basedir                       = /opt/percona-server
    datadir                       = /srv/myPORT/data
    log-error                     = /srv/myPORT/log/alert.log
    pid-file                      = /srv/myPORT/run/mysql.pid
    log_slave_updates             = 1
    log-bin                       = /srv/myPORT/log/mysql-bin
    binlog_format                 = row
    binlog_cache_size             = 2M
    max_binlog_cache_size         = 4G
    max_binlog_size               = 1G
    expire_logs_days              = 7
    relay-log                     = /srv/myPORT/log/relay-bin
    relay-log-info-file           = /srv/myPORT/log/relay-log.info
    relay-log-index               = /srv/myPORT/log/relay-log.index
    master-info-file              = /srv/myPORT/log/master.info
    relay-log-recovery            = true
    sync-relay-log-info           = 1
    explicit_defaults_for_timestamp
    key_buffer_size               = 2M
    sort_buffer_size              = 2M
    read_buffer_size              = 2M
    read_rnd_buffer_size          = 16M
    join_buffer_size              = 2M
    thread_cache_size             = 1024
    query_cache_size              = 1M
    query_cache_limit             = 1M
    query_cache_min_res_unit      = 2k
    table_open_cache              = 2048
    open_files_limit              = 65535
    back_log                      = 3000
    max_connections               = 4000
    max_user_connections          = 2500
    max_connect_errors            = 100
    max_allowed_packet            = 512M
    thread_stack                  = 192k
    default-storage-engine        = INNODB
    transaction_isolation         = READ-COMMITTED
    tmp_table_size                = 16M
    max_heap_table_size           = 64M
    bulk_insert_buffer_size       = 64M
    long_query_time               = 0.5
    slow_query_log                = on
    slow_query_log_file           = /srv/myPORT/log/slow.log
    skip-name-resolve
    innodb_buffer_pool_size       = 10G
    innodb_data_file_path         = ibdata1:2G:autoextend
    innodb_file_io_threads        = 24
    innodb_purge_threads          = 12
    innodb_read_io_threads        = 24
    innodb_write_io_threads       = 24
    innodb_thread_concurrency     = 24
    innodb_buffer_pool_instances  = 8
    innodb_flush_log_at_trx_commit= 1
    innodb_log_buffer_size        = 16M
    innodb_log_file_size          = 2G
    innodb_log_files_in_group     = 2
    innodb_max_dirty_pages_pct    = 75
    innodb_lock_wait_timeout      = 50
    innodb_file_per_table         = 1
    thread_handling               = pool-of-threads
    thread_pool_idle_timeout      = 180
    thread_pool_max_threads       = 5000
    thread_pool_size              = 24
    thread_pool_oversubscribe     = 10
    thread_pool_stall_limit       = 500
    [mysqldump]
    quick
    max_allow_packet              = 64M
    [mysql]
    no-auto-rehash
    [mysqlhotcopy]
    interactive-timeout

View Code