Comment 3 for bug 908531

Revision history for this message
piavlo (piavka) wrote :

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
max_user_connections = 1400
max_connect_errors = 4294967295

server-id = 4

innodb_use_purge_thread = 1
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_file_size = 512M
innodb_log_buffer_size = 4M
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_file_per_table = 1
innodb_support_xa = 0
innodb_adaptive_flushing = 0

innodb_auto_lru_dump = 300

innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_io_capacity = 200
innodb_read_ahead = linear
innodb_adaptive_checkpoint = estimate

innodb_log_block_size = 512
innodb_flush_neighbor_pages = 1

innodb_buffer_pool_size = 5G
innodb_additional_mem_pool_size = 32M

innodb_thread_concurrency = 4

auto_increment_increment = 2
auto_increment_offset = 1

log_slave_updates = 1
concurrent_insert = 1

replicate-same-server-id = 0
replicate-wild-ignore-table = mysql.%
replicate-wild-ignore-table = information_schema.%

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
slave_transaction_retries = 10

innodb_overwrite_relay_log_info = 0

long_query_time = 15
log_slow_rate_limit = 1

slow_query_log = 1
slow_query_log_file = /var/lib//mysql/slow_queries.log
slow_query_log_microseconds_timestamp = 1

log_slow_slave_statements = 0

log_slow_verbosity = microtime,query_plan,innodb

log_slow_filter = full_scan,full_join

tmpdir = /ephemeral/mysql/tmp

userstat_running = 1