1) Do you really want 7K of lines of schema/tables dump? There are about 300 tables.
All tables are innodb - except server 5 or 6 are myisam. There are several fogeign keys and partitions too.
2)The crash happens randomly - every X minutes or hours and server auto restarted by mysqld_safe
It happens on slave - doing only replication in MIXED mode.
3)The options are
1) Do you really want 7K of lines of schema/tables dump? There are about 300 tables.
All tables are innodb - except server 5 or 6 are myisam. There are several fogeign keys and partitions too.
2)The crash happens randomly - every X minutes or hours and server auto restarted by mysqld_safe
It happens on slave - doing only replication in MIXED mode.
3)The options are
max_connections = 1400 connections = 1400
max_user_
max_connect_errors = 4294967295
server-id = 4
innodb_ use_purge_ thread = 1 data_file_ path = ibdata1: 2000M;ibdata2: 10M:autoextend log_file_ size = 512M log_buffer_ size = 4M log_files_ in_group = 2 flush_log_ at_trx_ commit = 2 lock_wait_ timeout = 50 file_per_ table = 1 adaptive_ flushing = 0
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_support_xa = 0
innodb_
innodb_ auto_lru_ dump = 300
innodb_ read_io_ threads = 4 write_io_ threads = 4 adaptive_ checkpoint = estimate
innodb_
innodb_io_capacity = 200
innodb_read_ahead = linear
innodb_
innodb_ log_block_ size = 512 flush_neighbor_ pages = 1
innodb_
innodb_ buffer_ pool_size = 5G additional_ mem_pool_ size = 32M
innodb_
innodb_ thread_ concurrency = 4
auto_increment_ increment = 2 offset = 1
auto_increment_
log_slave_updates = 1
concurrent_insert = 1
replicate- same-server- id = 0 wild-ignore- table = mysql.% wild-ignore- table = information_ schema. %
replicate-
replicate-
log-bin = mysql-bin
log-bin-index = mysql-bin.index
sync_binlog = 0
expire_logs_days = 7
max_binlog_size = 1024M
relay_log = relay-bin
relay_log_index = relay-bin.index
log_bin_ trust_function_ creators = 1
binlog-format = MIXED
innodb_ locks_unsafe_ for_binlog = 1
innodb_ lock_wait_ timeout = 50 on_retries = 10
slave_transacti
innodb_ overwrite_ relay_log_ info = 0
long_query_time = 15
log_slow_rate_limit = 1
slow_query_log = 1 /mysql/ slow_queries. log log_microsecond s_timestamp = 1
slow_query_log_file = /var/lib/
slow_query_
log_slow_ slave_statement s = 0
log_slow_verbosity = microtime, query_plan, innodb
log_slow_filter = full_scan,full_join
tmpdir = /ephemeral/ mysql/tmp
userstat_running = 1