Comment 2 for bug 1702400

mysql 5.6.35

This has been running for a couple of months.

Here is my.cnf config,

[mysqld]
basedir = /usr
datadir = /mysql_data_new/db
plugin-dir = /usr/lib64/mysql/plugin
user = mysql
log-error = /var/log/mysql/mysqlacctarch01-prod.log
pid-file = /var/lib/mysql/mysql.pid
tmpdir = /mysql_data_new/tmp

###################################################
################## REPLICATION ####################
###################################################

#log-bin = mysqld-bin
log-bin = /mysql_data_new/binlogs/mysqlacctarch01-bin
log-bin-index = /mysql_data_new/binlogs/mysqlacctarch01-bin.index
relay-log = /mysql_data_new/binlogs/mysqlacctarch01-relay
relay-log-index = /mysql_data_new/binlogs/mysqlacctarch01-relay.index
relay-log-info-file = /mysql_data_new/binlogs/mysqlacctarch01-relay.info
binlog_format = row
gtid-mode = on
enforce-gtid-consistency
log-slave-updates
report-host = mysqlacctarch01-prod
server-id = 12
max_allowed_packet = 128M
max_connections = 1000
expire_logs_days = 4
binlog_cache_size = 8M

slave-skip-errors = 1032,1062

####################################################
################## PERFORMANCE #####################
####################################################

innodb_buffer_pool_size = 10G
innodb_flush_log_at_trx_commit = 2
max_heap_table_size = 4G
tmp_table_size = 4G
#max_heap_table_size = 32M
#tmp_table_size = 32M
thread_cache_size = 30
innodb_log_file_size = 2G
innodb_lock_wait_timeout = 150
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_read_io_threads = 16
innodb_write_io_threads = 16
innodb_file_format = Barracuda
innodb_sort_buffer_size = 71M
max_allowed_packet = 128M
max_connections = 1000
net_read_timeout = 60

####################################################
################## TOKUDB #####################
####################################################

tokudb_cache_size = 8G
tokudb_tmp_dir = /mysql_data_new/tmp
tokudb_row_format = TOKUDB_LZMA
innodb_use_native_aio=0

# skip-slave-start

[mysqld_safe]
preload-hotbackup
thp-setting=never