Comment 1 for bug 1667552

my.cnf

#
# Percona 5.6 InnoDB Master/Master config for 8GB RAM
#
#
[client]
socket = /var/run/mysql/mysql.sock
# Defaults for NOVA -- GBM #
default-character-set = utf8

[mysql]
port = 3306
socket = /var/run/mysql/mysql.sock

[mysql@upladevnsq01v ~]$ cat /etc/redhat-release
CentOS release 6.8 (Final)
[mysql@upladevnsq01v ~]$ cat /proc/meminfo
MemTotal: 16329908 kB

[mysqld]
# GENERAL #
read-only = ON
user = mysql
default-storage-engine = InnoDB
socket = /var/run/mysql/mysql.sock
pid-file = /var\/run\/mysqld\/mysql.pid
explicit-defaults-for-timestamp = 1
# Defaults for NOVA -- GBM #
character-set-server = utf8
collation-server = utf8_general_ci

# MyISAM #
key-buffer-size = 256M
myisam-recover-options = FORCE,BACKUP

# SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
sysdate-is-now = 1
innodb = FORCE
innodb-strict-mode = 1

# DATA STORAGE #
datadir = /data/mysql/
tmpdir = /data/mysql_tmp/

# BINARY LOGGING #
log-bin = /data/mysql/mysql-bin
expire-logs-days = 3
sync-binlog = 1

# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
read-buffer-size = 1048576
max-connections = 1000
thread-cache-size = 40
open-files-limit = 16384
table-definition-cache = 1000
table-open-cache = 1000

# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 512M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 9G

# LOGGING #
log-error = /var/log/mysql/mysql-error.log
log-queries-not-using-indexes = 0
slow-query-log = 1
long-query-time = 2
slow-query-log-file = /var/log/mysql/mysql-slow.log
log-slow-verbosity = full
log_timestamps = SYSTEM
log_error_verbosity = 2

# Replication settings
server-id = 1
auto_increment_increment = 2
auto_increment_offset = 1
relay_log = mysql-relay-bin
binlog_format = mixed
expire_logs_days = 2
report-host = upladevnsq01v
report-user = repl
master-info-repository = TABLE
relay-log-info-repository = TABLE
skip-slave-start = 1