##### MASTER SERVER ##### SHOW GLOBAL VARIABLES auto_increment_increment,1 auto_increment_offset,1 autocommit,ON automatic_sp_privileges,ON back_log,60 basedir,/usr/local big_tables,OFF bind_address,* binlog_cache_size,32768 binlog_checksum,CRC32 binlog_direct_non_transactional_updates,OFF binlog_format,STATEMENT binlog_max_flush_queue_time,0 binlog_order_commits,ON binlog_row_image,FULL binlog_rows_query_log_events,OFF binlog_stmt_cache_size,32768 bulk_insert_buffer_size,8388608 character_set_client,latin1 character_set_connection,latin1 character_set_database,latin1 character_set_filesystem,binary character_set_results,latin1 character_set_server,latin1 character_set_system,utf8 character_sets_dir,/usr/local/share/mysql/charsets/ collation_connection,latin1_swedish_ci collation_database,latin1_swedish_ci collation_server,latin1_swedish_ci completion_type,NO_CHAIN concurrent_insert,ALWAYS connect_timeout,10 core_file,OFF datadir,/var/db/mysql/ date_format,%Y-%m-%d datetime_format,%Y-%m-%d %H:%i:%s default_storage_engine,InnoDB default_tmp_storage_engine,InnoDB default_week_format,0 delay_key_write,ON delayed_insert_limit,100 delayed_insert_timeout,300 delayed_queue_size,1000 disconnect_on_expired_password,ON div_precision_increment,4 end_markers_in_json,OFF enforce_gtid_consistency,OFF eq_range_index_dive_limit,10 event_scheduler,OFF expire_logs_days,14 explicit_defaults_for_timestamp,OFF flush,OFF flush_time,0 foreign_key_checks,ON ft_boolean_syntax,+ -><()~*:""&| ft_max_word_len,84 ft_min_word_len,4 ft_query_expansion_limit,20 ft_stopword_file,(built-in) general_log,OFF general_log_file,/var/db/mysql/subscrdb.log group_concat_max_len,10240 gtid_executed, gtid_mode,OFF gtid_owned, gtid_purged, have_compress,YES have_crypt,YES have_dynamic_loading,YES have_geometry,YES have_openssl,DISABLED have_profiling,YES have_query_cache,YES have_rtree_keys,YES have_ssl,DISABLED have_symlink,YES host_cache_size,178 hostname,subscrdb.nl.playfon.ru ignore_builtin_innodb,OFF ignore_db_dirs, init_connect, init_file, init_slave, innodb_adaptive_flushing,ON innodb_adaptive_flushing_lwm,10 innodb_adaptive_hash_index,ON innodb_adaptive_max_sleep_delay,150000 innodb_additional_mem_pool_size,8388608 innodb_api_bk_commit_interval,5 innodb_api_disable_rowlock,OFF innodb_api_enable_binlog,OFF innodb_api_enable_mdl,OFF innodb_api_trx_level,0 innodb_autoextend_increment,64 innodb_autoinc_lock_mode,1 innodb_buffer_pool_dump_at_shutdown,OFF innodb_buffer_pool_dump_now,OFF innodb_buffer_pool_filename,ib_buffer_pool innodb_buffer_pool_instances,8 innodb_buffer_pool_load_abort,OFF innodb_buffer_pool_load_at_startup,OFF innodb_buffer_pool_load_now,OFF innodb_buffer_pool_size,5368709120 innodb_change_buffer_max_size,25 innodb_change_buffering,all innodb_checksum_algorithm,innodb innodb_checksums,ON innodb_cmp_per_index_enabled,OFF innodb_commit_concurrency,0 innodb_compression_failure_threshold_pct,5 innodb_compression_level,6 innodb_compression_pad_pct_max,50 innodb_concurrency_tickets,5000 innodb_data_file_path,ibdata1:12M:autoextend innodb_data_home_dir, innodb_disable_sort_file_cache,OFF innodb_doublewrite,OFF innodb_fast_shutdown,1 innodb_file_format,Antelope innodb_file_format_check,ON innodb_file_format_max,Antelope innodb_file_per_table,ON innodb_flush_log_at_timeout,1 innodb_flush_log_at_trx_commit,1 innodb_flush_method,O_DIRECT innodb_flush_neighbors,1 innodb_flushing_avg_loops,30 innodb_force_load_corrupted,OFF innodb_force_recovery,0 innodb_ft_aux_table, innodb_ft_cache_size,8000000 innodb_ft_enable_diag_print,OFF innodb_ft_enable_stopword,ON innodb_ft_max_token_size,84 innodb_ft_min_token_size,3 innodb_ft_num_word_optimize,2000 innodb_ft_server_stopword_table, innodb_ft_sort_pll_degree,2 innodb_ft_user_stopword_table, innodb_io_capacity,200 innodb_io_capacity_max,2000 innodb_large_prefix,OFF innodb_lock_wait_timeout,50 innodb_locks_unsafe_for_binlog,OFF innodb_log_buffer_size,8388608 innodb_log_file_size,50331648 innodb_log_files_in_group,2 innodb_log_group_home_dir,./ innodb_lru_scan_depth,1024 innodb_max_dirty_pages_pct,75 innodb_max_dirty_pages_pct_lwm,0 innodb_max_purge_lag,0 innodb_max_purge_lag_delay,0 innodb_mirrored_log_groups,1 innodb_monitor_disable, innodb_monitor_enable, innodb_monitor_reset, innodb_monitor_reset_all, innodb_old_blocks_pct,37 innodb_old_blocks_time,1000 innodb_online_alter_log_max_size,134217728 innodb_open_files,2000 innodb_optimize_fulltext_only,OFF innodb_page_size,16384 innodb_print_all_deadlocks,OFF innodb_purge_batch_size,300 innodb_purge_threads,1 innodb_random_read_ahead,OFF innodb_read_ahead_threshold,56 innodb_read_io_threads,4 innodb_read_only,OFF innodb_replication_delay,0 innodb_rollback_on_timeout,OFF innodb_rollback_segments,128 innodb_sort_buffer_size,1048576 innodb_spin_wait_delay,6 innodb_stats_auto_recalc,ON innodb_stats_method,nulls_equal innodb_stats_on_metadata,OFF innodb_stats_persistent,ON innodb_stats_persistent_sample_pages,20 innodb_stats_sample_pages,8 innodb_stats_transient_sample_pages,8 innodb_strict_mode,OFF innodb_support_xa,ON innodb_sync_array_size,1 innodb_sync_spin_loops,30 innodb_table_locks,ON innodb_thread_concurrency,0 innodb_thread_sleep_delay,10000 innodb_undo_directory,. innodb_undo_logs,128 innodb_undo_tablespaces,0 innodb_use_native_aio,OFF innodb_use_sys_malloc,ON innodb_version,1.2.10 innodb_write_io_threads,4 interactive_timeout,28800 join_buffer_size,2097152 keep_files_on_create,OFF key_buffer_size,268435456 key_cache_age_threshold,300 key_cache_block_size,1024 key_cache_division_limit,100 large_files_support,ON large_page_size,0 large_pages,OFF lc_messages,en_US lc_messages_dir,/usr/local/share/mysql/ lc_time_names,en_US license,GPL local_infile,ON lock_wait_timeout,31536000 locked_in_memory,OFF log_bin,ON log_bin_basename,/var/db/mysql/subscrdb-bin log_bin_index,/var/db/mysql/subscrdb-bin.index log_bin_trust_function_creators,OFF log_bin_use_v1_row_events,OFF log_error,/var/db/mysql/subscrdb.nl.playfon.ru.err log_output,FILE log_queries_not_using_indexes,ON log_slave_updates,ON log_throttle_queries_not_using_indexes,0 log_warnings,1 long_query_time,10.000000 low_priority_updates,OFF lower_case_file_system,OFF lower_case_table_names,0 master_info_repository,FILE master_verify_checksum,OFF max_allowed_packet,104857600 max_binlog_cache_size,18446744073709547520 max_binlog_size,1073741824 max_binlog_stmt_cache_size,18446744073709547520 max_connect_errors,10000000 max_connections,50 max_delayed_threads,20 max_error_count,64 max_heap_table_size,16777216 max_insert_delayed_threads,20 max_join_size,18446744073709551615 max_length_for_sort_data,1024 max_prepared_stmt_count,16382 max_relay_log_size,0 max_seeks_for_key,18446744073709551615 max_sort_length,1024 max_sp_recursion_depth,0 max_tmp_tables,32 max_user_connections,45 max_write_lock_count,18446744073709551615 metadata_locks_cache_size,1024 metadata_locks_hash_instances,8 min_examined_row_limit,0 multi_range_count,256 myisam_data_pointer_size,6 myisam_max_sort_file_size,9223372036853727232 myisam_mmap_size,18446744073709551615 myisam_recover_options,OFF myisam_repair_threads,8 myisam_sort_buffer_size,33554432 myisam_stats_method,nulls_unequal myisam_use_mmap,OFF net_buffer_length,16384 net_read_timeout,30 net_retry_count,10 net_write_timeout,60 new,OFF old,OFF old_alter_table,OFF old_passwords,0 open_files_limit,11095 optimizer_prune_level,1 optimizer_search_depth,62 optimizer_switch,index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on optimizer_trace,enabled=off,one_line=off optimizer_trace_features,greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on optimizer_trace_limit,1 optimizer_trace_max_mem_size,16384 optimizer_trace_offset,-1 performance_schema,ON performance_schema_accounts_size,10 performance_schema_digests_size,1000 performance_schema_events_stages_history_long_size,100 performance_schema_events_stages_history_size,5 performance_schema_events_statements_history_long_size,100 performance_schema_events_statements_history_size,5 performance_schema_events_waits_history_long_size,100 performance_schema_events_waits_history_size,5 performance_schema_hosts_size,20 performance_schema_max_cond_classes,80 performance_schema_max_cond_instances,612 performance_schema_max_file_classes,50 performance_schema_max_file_handles,32768 performance_schema_max_file_instances,77778 performance_schema_max_mutex_classes,200 performance_schema_max_mutex_instances,2945 performance_schema_max_rwlock_classes,30 performance_schema_max_rwlock_instances,1612 performance_schema_max_socket_classes,10 performance_schema_max_socket_instances,67 performance_schema_max_stage_classes,150 performance_schema_max_statement_classes,167 performance_schema_max_table_handles,2223 performance_schema_max_table_instances,445 performance_schema_max_thread_classes,50 performance_schema_max_thread_instances,112 performance_schema_session_connect_attrs_size,512 performance_schema_setup_actors_size,100 performance_schema_setup_objects_size,100 performance_schema_users_size,5 pid_file,/var/db/mysql/subscrdb.nl.playfon.ru.pid plugin_dir,/usr/local/lib/mysql/plugin/ port,3306 preload_buffer_size,32768 profiling,OFF profiling_history_size,15 protocol_version,10 query_alloc_block_size,8192 query_cache_limit,1048576 query_cache_min_res_unit,4096 query_cache_size,205520896 query_cache_type,OFF query_cache_wlock_invalidate,OFF query_prealloc_size,8192 range_alloc_block_size,4096 read_buffer_size,4194304 read_only,OFF read_rnd_buffer_size,8388608 relay_log,subscrdb-nl-relay-bin relay_log_basename,/var/db/mysql/subscrdb-nl-relay-bin relay_log_index,/var/db/mysql/subscrdb-nl-relay-bin.index relay_log_info_file,relay-log.info relay_log_info_repository,FILE relay_log_purge,ON relay_log_recovery,OFF relay_log_space_limit,0 report_host, report_password, report_port,3306 report_user, secure_auth,ON secure_file_priv, server_id,197220 server_id_bits,32 server_uuid,bbc41eb2-8bf9-11e2-8e48-32f5c5e5cacd skip_external_locking,ON skip_name_resolve,OFF skip_networking,OFF skip_show_database,OFF slave_allow_batching,OFF slave_checkpoint_group,512 slave_checkpoint_period,300 slave_compressed_protocol,OFF slave_exec_mode,STRICT slave_load_tmpdir,/var/tmp/ slave_max_allowed_packet,1073741824 slave_net_timeout,3600 slave_parallel_workers,0 slave_pending_jobs_size_max,16777216 slave_rows_search_algorithms,TABLE_SCAN,INDEX_SCAN slave_skip_errors,OFF slave_sql_verify_checksum,ON slave_transaction_retries,10 slave_type_conversions, slow_launch_time,2 slow_query_log,OFF slow_query_log_file,/var/db/mysql/subscrdb-slow.log socket,/tmp/mysql.sock sort_buffer_size,33554432 sql_auto_is_null,OFF sql_big_selects,ON sql_buffer_result,OFF sql_log_bin,ON sql_log_off,OFF sql_mode,NO_ENGINE_SUBSTITUTION sql_notes,ON sql_quote_show_create,ON sql_safe_updates,OFF sql_select_limit,18446744073709551615 sql_slave_skip_counter,0 sql_warnings,OFF ssl_ca, ssl_capath, ssl_cert, ssl_cipher, ssl_crl, ssl_crlpath, ssl_key, storage_engine,InnoDB stored_program_cache,256 sync_binlog,0 sync_frm,ON sync_master_info,10000 sync_relay_log,10000 sync_relay_log_info,10000 system_time_zone,MSK table_definition_cache,1400 table_open_cache,2000 table_open_cache_instances,1 thread_cache_size,32 thread_concurrency,8 thread_handling,one-thread-per-connection thread_stack,262144 time_format,%H:%i:%s time_zone,SYSTEM timed_mutexes,OFF tmp_table_size,16777216 tmpdir,/var/tmp/ transaction_alloc_block_size,8192 transaction_prealloc_size,4096 tx_isolation,REPEATABLE-READ tx_read_only,OFF unique_checks,ON updatable_views_with_limit,YES version,5.6.10-log version_comment,Source distribution version_compile_machine,amd64 version_compile_os,FreeBSD9.0 wait_timeout,28800 SHOW SLAVE STATUS *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: xxx.xxx.xxx.xxx Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: db1-bin.001623 Read_Master_Log_Pos: 929682844 Relay_Log_File: subscrdb-nl-relay-bin.000545 Relay_Log_Pos: 929683001 Relay_Master_Log_File: db1-bin.001623 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: mc.stat Replicate_Ignore_Table: mc.adds Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 929682844 Relay_Log_Space: 929683217 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1429 Master_UUID: Master_Info_File: /var/db/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 SHOW MASTER STATUS *************************** 1. row *************************** File: subscrdb-bin.000742 Position: 249136718 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: ##### SLAVE SERVER ##### SHOW GLOBAL VARIABLES auto_increment_increment,1 auto_increment_offset,1 autocommit,ON automatic_sp_privileges,ON back_log,60 basedir,/usr/local big_tables,OFF bind_address,* binlog_cache_size,32768 binlog_checksum,CRC32 binlog_direct_non_transactional_updates,OFF binlog_format,STATEMENT binlog_max_flush_queue_time,0 binlog_order_commits,ON binlog_row_image,FULL binlog_rows_query_log_events,OFF binlog_stmt_cache_size,32768 bulk_insert_buffer_size,8388608 character_set_client,latin1 character_set_connection,latin1 character_set_database,latin1 character_set_filesystem,binary character_set_results,latin1 character_set_server,latin1 character_set_system,utf8 character_sets_dir,/usr/local/share/mysql/charsets/ collation_connection,latin1_swedish_ci collation_database,latin1_swedish_ci collation_server,latin1_swedish_ci completion_type,NO_CHAIN concurrent_insert,ALWAYS connect_timeout,10 core_file,OFF datadir,/var/db/mysql/ date_format,%Y-%m-%d datetime_format,%Y-%m-%d %H:%i:%s default_storage_engine,InnoDB default_tmp_storage_engine,InnoDB default_week_format,0 delay_key_write,ON delayed_insert_limit,100 delayed_insert_timeout,300 delayed_queue_size,1000 disconnect_on_expired_password,ON div_precision_increment,4 end_markers_in_json,OFF enforce_gtid_consistency,OFF eq_range_index_dive_limit,10 event_scheduler,OFF expire_logs_days,14 explicit_defaults_for_timestamp,OFF flush,OFF flush_time,0 foreign_key_checks,ON ft_boolean_syntax,+ -><()~*:""&| ft_max_word_len,84 ft_min_word_len,4 ft_query_expansion_limit,20 ft_stopword_file,(built-in) general_log,OFF general_log_file,/var/db/mysql/subscrdb.log group_concat_max_len,10240 gtid_executed, gtid_mode,OFF gtid_owned, gtid_purged, have_compress,YES have_crypt,YES have_dynamic_loading,YES have_geometry,YES have_openssl,DISABLED have_profiling,YES have_query_cache,YES have_rtree_keys,YES have_ssl,DISABLED have_symlink,YES host_cache_size,178 hostname,subscrdb.de.playfon.ru ignore_builtin_innodb,OFF ignore_db_dirs, init_connect, init_file, init_slave, innodb_adaptive_flushing,ON innodb_adaptive_flushing_lwm,10 innodb_adaptive_hash_index,ON innodb_adaptive_max_sleep_delay,150000 innodb_additional_mem_pool_size,8388608 innodb_api_bk_commit_interval,5 innodb_api_disable_rowlock,OFF innodb_api_enable_binlog,OFF innodb_api_enable_mdl,OFF innodb_api_trx_level,0 innodb_autoextend_increment,64 innodb_autoinc_lock_mode,1 innodb_buffer_pool_dump_at_shutdown,OFF innodb_buffer_pool_dump_now,OFF innodb_buffer_pool_filename,ib_buffer_pool innodb_buffer_pool_instances,8 innodb_buffer_pool_load_abort,OFF innodb_buffer_pool_load_at_startup,OFF innodb_buffer_pool_load_now,OFF innodb_buffer_pool_size,5368709120 innodb_change_buffer_max_size,25 innodb_change_buffering,all innodb_checksum_algorithm,innodb innodb_checksums,ON innodb_cmp_per_index_enabled,OFF innodb_commit_concurrency,0 innodb_compression_failure_threshold_pct,5 innodb_compression_level,6 innodb_compression_pad_pct_max,50 innodb_concurrency_tickets,5000 innodb_data_file_path,ibdata1:12M:autoextend innodb_data_home_dir, innodb_disable_sort_file_cache,OFF innodb_doublewrite,OFF innodb_fast_shutdown,1 innodb_file_format,Antelope innodb_file_format_check,ON innodb_file_format_max,Antelope innodb_file_per_table,ON innodb_flush_log_at_timeout,1 innodb_flush_log_at_trx_commit,1 innodb_flush_method,O_DIRECT innodb_flush_neighbors,1 innodb_flushing_avg_loops,30 innodb_force_load_corrupted,OFF innodb_force_recovery,0 innodb_ft_aux_table, innodb_ft_cache_size,8000000 innodb_ft_enable_diag_print,OFF innodb_ft_enable_stopword,ON innodb_ft_max_token_size,84 innodb_ft_min_token_size,3 innodb_ft_num_word_optimize,2000 innodb_ft_server_stopword_table, innodb_ft_sort_pll_degree,2 innodb_ft_user_stopword_table, innodb_io_capacity,200 innodb_io_capacity_max,2000 innodb_large_prefix,OFF innodb_lock_wait_timeout,50 innodb_locks_unsafe_for_binlog,OFF innodb_log_buffer_size,8388608 innodb_log_file_size,50331648 innodb_log_files_in_group,2 innodb_log_group_home_dir,./ innodb_lru_scan_depth,1024 innodb_max_dirty_pages_pct,75 innodb_max_dirty_pages_pct_lwm,0 innodb_max_purge_lag,0 innodb_max_purge_lag_delay,0 innodb_mirrored_log_groups,1 innodb_monitor_disable, innodb_monitor_enable, innodb_monitor_reset, innodb_monitor_reset_all, innodb_old_blocks_pct,37 innodb_old_blocks_time,1000 innodb_online_alter_log_max_size,134217728 innodb_open_files,2000 innodb_optimize_fulltext_only,OFF innodb_page_size,16384 innodb_print_all_deadlocks,OFF innodb_purge_batch_size,300 innodb_purge_threads,1 innodb_random_read_ahead,OFF innodb_read_ahead_threshold,56 innodb_read_io_threads,4 innodb_read_only,OFF innodb_replication_delay,0 innodb_rollback_on_timeout,OFF innodb_rollback_segments,128 innodb_sort_buffer_size,1048576 innodb_spin_wait_delay,6 innodb_stats_auto_recalc,ON innodb_stats_method,nulls_equal innodb_stats_on_metadata,OFF innodb_stats_persistent,ON innodb_stats_persistent_sample_pages,20 innodb_stats_sample_pages,8 innodb_stats_transient_sample_pages,8 innodb_strict_mode,OFF innodb_support_xa,ON innodb_sync_array_size,1 innodb_sync_spin_loops,30 innodb_table_locks,ON innodb_thread_concurrency,0 innodb_thread_sleep_delay,10000 innodb_undo_directory,. innodb_undo_logs,128 innodb_undo_tablespaces,0 innodb_use_native_aio,OFF innodb_use_sys_malloc,ON innodb_version,1.2.10 innodb_write_io_threads,4 interactive_timeout,28800 join_buffer_size,2097152 keep_files_on_create,OFF key_buffer_size,268435456 key_cache_age_threshold,300 key_cache_block_size,1024 key_cache_division_limit,100 large_files_support,ON large_page_size,0 large_pages,OFF lc_messages,en_US lc_messages_dir,/usr/local/share/mysql/ lc_time_names,en_US license,GPL local_infile,ON lock_wait_timeout,31536000 locked_in_memory,OFF log_bin,OFF log_bin_basename, log_bin_index, log_bin_trust_function_creators,OFF log_bin_use_v1_row_events,OFF log_error,/var/db/mysql/subscrdb.de.playfon.ru.err log_output,FILE log_queries_not_using_indexes,ON log_slave_updates,OFF log_throttle_queries_not_using_indexes,0 log_warnings,1 long_query_time,10.000000 low_priority_updates,OFF lower_case_file_system,OFF lower_case_table_names,0 master_info_repository,FILE master_verify_checksum,OFF max_allowed_packet,104857600 max_binlog_cache_size,18446744073709547520 max_binlog_size,1073741824 max_binlog_stmt_cache_size,18446744073709547520 max_connect_errors,10000000 max_connections,50 max_delayed_threads,20 max_error_count,64 max_heap_table_size,134217728 max_insert_delayed_threads,20 max_join_size,18446744073709551615 max_length_for_sort_data,1024 max_prepared_stmt_count,16382 max_relay_log_size,0 max_seeks_for_key,18446744073709551615 max_sort_length,1024 max_sp_recursion_depth,0 max_tmp_tables,32 max_user_connections,45 max_write_lock_count,18446744073709551615 metadata_locks_cache_size,1024 metadata_locks_hash_instances,8 min_examined_row_limit,0 multi_range_count,256 myisam_data_pointer_size,6 myisam_max_sort_file_size,9223372036853727232 myisam_mmap_size,18446744073709551615 myisam_recover_options,OFF myisam_repair_threads,8 myisam_sort_buffer_size,33554432 myisam_stats_method,nulls_unequal myisam_use_mmap,OFF net_buffer_length,16384 net_read_timeout,30 net_retry_count,10 net_write_timeout,60 new,OFF old,OFF old_alter_table,OFF old_passwords,0 open_files_limit,11095 optimizer_prune_level,1 optimizer_search_depth,62 optimizer_switch,index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on optimizer_trace,enabled=off,one_line=off optimizer_trace_features,greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on optimizer_trace_limit,1 optimizer_trace_max_mem_size,16384 optimizer_trace_offset,-1 performance_schema,ON performance_schema_accounts_size,10 performance_schema_digests_size,1000 performance_schema_events_stages_history_long_size,100 performance_schema_events_stages_history_size,5 performance_schema_events_statements_history_long_size,100 performance_schema_events_statements_history_size,5 performance_schema_events_waits_history_long_size,100 performance_schema_events_waits_history_size,5 performance_schema_hosts_size,20 performance_schema_max_cond_classes,80 performance_schema_max_cond_instances,612 performance_schema_max_file_classes,50 performance_schema_max_file_handles,32768 performance_schema_max_file_instances,77778 performance_schema_max_mutex_classes,200 performance_schema_max_mutex_instances,2945 performance_schema_max_rwlock_classes,30 performance_schema_max_rwlock_instances,1612 performance_schema_max_socket_classes,10 performance_schema_max_socket_instances,67 performance_schema_max_stage_classes,150 performance_schema_max_statement_classes,167 performance_schema_max_table_handles,2223 performance_schema_max_table_instances,445 performance_schema_max_thread_classes,50 performance_schema_max_thread_instances,112 performance_schema_session_connect_attrs_size,512 performance_schema_setup_actors_size,100 performance_schema_setup_objects_size,100 performance_schema_users_size,5 pid_file,/var/db/mysql/subscrdb.de.playfon.ru.pid plugin_dir,/usr/local/lib/mysql/plugin/ port,3306 preload_buffer_size,32768 profiling,OFF profiling_history_size,15 protocol_version,10 query_alloc_block_size,8192 query_cache_limit,1048576 query_cache_min_res_unit,4096 query_cache_size,205520896 query_cache_type,OFF query_cache_wlock_invalidate,OFF query_prealloc_size,8192 range_alloc_block_size,4096 read_buffer_size,4194304 read_only,OFF read_rnd_buffer_size,8388608 relay_log, relay_log_basename, relay_log_index, relay_log_info_file,relay-log.info relay_log_info_repository,FILE relay_log_purge,ON relay_log_recovery,OFF relay_log_space_limit,0 report_host, report_password, report_port,3306 report_user, secure_auth,ON secure_file_priv, server_id,22472 server_id_bits,32 server_uuid,226cf505-88a9-11e2-b8aa-b2b992a87e07 skip_external_locking,ON skip_name_resolve,OFF skip_networking,OFF skip_show_database,OFF slave_allow_batching,OFF slave_checkpoint_group,512 slave_checkpoint_period,300 slave_compressed_protocol,OFF slave_exec_mode,STRICT slave_load_tmpdir,/tmp/ slave_max_allowed_packet,1073741824 slave_net_timeout,3600 slave_parallel_workers,0 slave_pending_jobs_size_max,16777216 slave_rows_search_algorithms,TABLE_SCAN,INDEX_SCAN slave_skip_errors,OFF slave_sql_verify_checksum,ON slave_transaction_retries,10 slave_type_conversions, slow_launch_time,2 slow_query_log,ON slow_query_log_file,mysql_slow.log socket,/tmp/mysql.sock sort_buffer_size,33554432 sql_auto_is_null,OFF sql_big_selects,ON sql_buffer_result,OFF sql_log_bin,ON sql_log_off,OFF sql_mode,NO_ENGINE_SUBSTITUTION sql_notes,ON sql_quote_show_create,ON sql_safe_updates,OFF sql_select_limit,18446744073709551615 sql_slave_skip_counter,0 sql_warnings,OFF ssl_ca, ssl_capath, ssl_cert, ssl_cipher, ssl_crl, ssl_crlpath, ssl_key, storage_engine,InnoDB stored_program_cache,256 sync_binlog,0 sync_frm,ON sync_master_info,10000 sync_relay_log,10000 sync_relay_log_info,10000 system_time_zone,MSK table_definition_cache,1400 table_open_cache,2000 table_open_cache_instances,1 thread_cache_size,32 thread_concurrency,8 thread_handling,one-thread-per-connection thread_stack,262144 time_format,%H:%i:%s time_zone,SYSTEM timed_mutexes,OFF tmp_table_size,134217728 tmpdir,/tmp/ transaction_alloc_block_size,8192 transaction_prealloc_size,4096 tx_isolation,READ-COMMITTED tx_read_only,OFF unique_checks,ON updatable_views_with_limit,YES version,5.6.10-log version_comment,Source distribution version_compile_machine,amd64 version_compile_os,FreeBSD9.1 wait_timeout,28800 SHOW SLAVE STATUS *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: xxx.xxx.xxx.xxx Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: subscrdb-bin.000742 Read_Master_Log_Pos: 232785394 Relay_Log_File: subscrdb-relay-bin.000029 Relay_Log_Pos: 232785560 Relay_Master_Log_File: subscrdb-bin.000742 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: %.% Replicate_Wild_Ignore_Table: mysql.%,test.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 232785394 Relay_Log_Space: 232785786 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 197220 Master_UUID: bbc41eb2-8bf9-11e2-8e48-32f5c5e5cacd Master_Info_File: /var/db/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 SHOW MASTER STATUS is empty