Comment 1 for bug 1376597

Revision history for this message
Miguel Angel Nieto (miguelangelnieto) wrote :

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