[client]
#max_allowed_packet             = 1G
#password       = your_password
#port            = 3306
socket          = /var/lib/mysql/mysql.sock

[mysqld]
port            = 3306
#federated
#large-pages
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/var/lib/mysql/TMP
log_error=/var/log/mysql/mysqld.log
slow_query_log_file = /var/log/mysql/mysql-slow.log
#socket=/home/mysql/mysql.sock
user=mysql

gtid_domain_id          = 1
gtid_strict_mode        = 1

skip-name-resolve=1
read_only = OFF

wait_timeout = 1800
interactive_timeout = 28800

default_storage_engine = InnoDB
max_allowed_packet              = 128M
group_concat_max_len            = 64M

query_cache_type                = 0
query_cache_size                = 0
key_buffer_size                 = 128K

tmp_table_size                  = 64M
max_heap_table_size             = 512M
open_files_limit                = 8192
table_open_cache                = 4000
table_definition_cache          = 3000

thread_handling                 = pool-of-threads
#thread_pool_max_threads = 256

#start test block-----------------------------------
read_buffer_size                = 10M
sort_buffer_size                = 10M
max_binlog_cache_size           = 500M
max_binlog_stmt_cache_size      = 10M

join_buffer_size                = 100M
#end test block-------------------------------------

long_query_time = 10
slow_query_log='ON'
autocommit='ON'
#log-queries-not-using-indexes

bind-address = 0.0.0.0
server-id = 911
binlog_format=MIXED
sync_binlog=0
expire_logs_days = 3
log-bin=mysql-bin
log-slave-updates=true
replicate-ignore-table = prologis_log.email_log_content_archive

#slave-parallel-workers=4
#slave_preserve_commit_order=1
#slave-parallel-type=LOGICAL_CLOCK

max_connections                 = 250
max_user_connections            = 10000
max_connect_errors              = 10000

innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size         = 48G
innodb_log_file_size            = 6G
#innodb_buffer_pool_size         = 8G
#innodb_log_file_size            = 1G
innodb_log_buffer_size          = 40M
innodb_flush_log_at_trx_commit  = 2
innodb_lock_wait_timeout        = 3
innodb_file_per_table           = 1

innodb_strict_mode              = OFF

sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#sql_mode = NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

optimizer_search_depth           = 0

performance_schema=ON
#performance-schema-instrument='memory/%=COUNTED'

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
max_allowed_packet = 1G


#!includedir /etc/percona-server.conf.d/
#max-execution-time               = 3600000