This is the my.cnf I used when trying to reproduce another bug:
[client] loose-default-character-set = utf8mb4 port = 3306
[isamchk] key_buffer = 16M
[mysql] default-character-set = utf8mb4 max_allowed_packet = 64M
[mysqld] binlog_cache_size = 32M binlog_format = ROW character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci default-storage-engine = INNODB expire_logs_days = 10 init-connect = 'SET collation_connection = utf8mb4_unicode_ci; SET NAMES utf8mb4' innodb_autoinc_lock_mode = 2 innodb_file_format = Barracuda innodb_file_per_table = true innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT innodb_large_prefix = true innodb_lock_wait_timeout = 30 innodb_locks_unsafe_for_binlog = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 50331648
key_buffer = 16M log_bin = mysql-bin.log log_error = error.log log_slave_updates = true log_slow_verbosity = microtime,query_plan,innodb long_query_time = 1 max_allowed_packet = 64M max_binlog_size = 100M max_connections = 800 max_heap_table_size = 67108864 myisam-recover = BACKUP open_files_limit = 65535 port = 3306 query_cache_size = 0 query_cache_type = 0 server-id = 2127359171 skip-external-locking = true slave-net-timeout = 10 sql-mode = NO_ENGINE_SUBSTITUTION table_definition_cache = 1024 table_open_cache = 2048 thread_cache_size = 80 thread_stack = 192K thread_statistics = OFF tmp_table_size = 67108864 user = mysql userstat = ON wsrep_OSU_method = TOI wsrep_causal_reads = ON wsrep_cluster_address = gcomm://192.168.1.106,192.168.1.107,192.168.1.108 wsrep_cluster_name = mycluster wsrep_node_address = 192.168.1.106 wsrep_node_name = xtradb1 wsrep_provider = /usr/lib/libgalera_smm.so wsrep_slave_threads = 64 wsrep_sst_auth = sst:sst wsrep_sst_method = xtrabackup-v2 innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql [xtrabackup] default-character-set = latin1
This is the my.cnf I used when trying to reproduce another bug:
[client] default- character- set = utf8mb4
loose-
port = 3306
[isamchk]
key_buffer = 16M
[mysql] character- set = utf8mb4 packet = 64M
default-
max_allowed_
[mysqld] set-client- handshake = FALSE set-server = utf8mb4 storage- engine = INNODB connection = utf8mb4_unicode_ci; SET NAMES utf8mb4' autoinc_ lock_mode = 2 file_format = Barracuda file_per_ table = true flush_log_ at_trx_ commit = 0 flush_method = O_DIRECT large_prefix = true lock_wait_ timeout = 30 locks_unsafe_ for_binlog = 1 log_buffer_ size = 8M log_file_ size = 50331648
binlog_cache_size = 32M
binlog_format = ROW
character-
character-
collation-server = utf8mb4_unicode_ci
default-
expire_logs_days = 10
init-connect = 'SET collation_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
key_buffer = 16M verbosity = microtime, query_plan, innodb packet = 64M table_size = 67108864 external- locking = true SUBSTITUTION definition_ cache = 1024 causal_ reads = ON cluster_ address = gcomm:/ /192.168. 1.106,192. 168.1.107, 192.168. 1.108 cluster_ name = mycluster node_address = 192.168.1.106 libgalera_ smm.so slave_threads = 64 data_home_ dir = /var/lib/mysql log_group_ home_dir = /var/lib/mysql character- set = latin1
log_bin = mysql-bin.log
log_error = error.log
log_slave_updates = true
log_slow_
long_query_time = 1
max_allowed_
max_binlog_size = 100M
max_connections = 800
max_heap_
myisam-recover = BACKUP
open_files_limit = 65535
port = 3306
query_cache_size = 0
query_cache_type = 0
server-id = 2127359171
skip-
slave-net-timeout = 10
sql-mode = NO_ENGINE_
table_
table_open_cache = 2048
thread_cache_size = 80
thread_stack = 192K
thread_statistics = OFF
tmp_table_size = 67108864
user = mysql
userstat = ON
wsrep_OSU_method = TOI
wsrep_
wsrep_
wsrep_
wsrep_
wsrep_node_name = xtradb1
wsrep_provider = /usr/lib/
wsrep_
wsrep_sst_auth = sst:sst
wsrep_sst_method = xtrabackup-v2
innodb_
innodb_
[xtrabackup]
default-