[mysqld] socket = /home/mysql/data3054/tmp/mysql.sock datadir = /home/mysql/data3054/dbs3054 tmpdir = /home/mysql/data3054/tmp port = 3054 back_log = 50 character_set_server = utf8 default-storage-engine = INNODB max_connect_errors = 20 max_connections = 2170 max_user_connections = 2170 disable_change_password = on reserved_connections = 170 max_heap_table_size = 64M max_allowed_packet = 160M max_binlog_size = 500M thread_stack = 256K interactive_timeout = 7200 wait_timeout = 86400 sort_buffer_size = 2M read_buffer_size = 1M read_rnd_buffer_size = 1M join_buffer_size = 1M net_buffer_length = 16K thread_cache_size = 100 ft_min_word_len = 4 transaction_isolation = READ-COMMITTED tmp_table_size = 16777216 table_cache = 100 skip_name_resolve core-file lower_case_table_names = 1 log_bin_trust_function_creators = 1 log-bin = /home/mysql/data3054/mysql/mysql-bin.log log-bin-index = /home/mysql/data3054/mysql/master-log-bin.index log-error = /home/mysql/data3054/mysql/master-error.log relay-log = /home/mysql/data3054/mysql/slave-relay.log relay-log-info-file = /home/mysql/data3054/mysql/slave-relay-log.info relay-log-index = /home/mysql/data3054/mysql/slave-relay-log.index master-info-file = /home/mysql/data3054/mysql/master.info log-slave-updates = 1 binlog_cache_size = 1M sync_binlog = 1 log_warnings slow_query_log_file = /home/mysql/data3054/mysql/slow_query.log slow_query_log = 1 log_output = TABLE long_query_time = 1800 binlog_format = ROW server_id = 824922284 auto_increment_increment = 1 auto_increment_offset = 1 slave_skip_errors = 1062 slave_net_timeout = 60 key_buffer_size = 16M bulk_insert_buffer_size = 4M myisam_sort_buffer_size = 262144 myisam_max_sort_file_size = 2048K myisam_repair_threads = 1 myisam_recover_options = FORCE innodb_data_home_dir = /home/mysql/data3054/mysql innodb_log_group_home_dir = /home/mysql/data3054/mysql innodb_additional_mem_pool_size = 2M innodb_buffer_pool_size = 9600M innodb_data_file_path = ibdata1:200M:autoextend innodb_file_per_table innodb_file_io_threads = 4 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 1500M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 75 innodb_flush_method = O_DIRECT innodb_lock_wait_timeout = 3000 innodb_doublewrite = 1 innodb_rollback_on_timeout = OFF innodb_autoinc_lock_mode = 1 innodb_read_io_threads = 4 innodb_write_io_threads = 4 innodb_io_capacity = 2000 innodb_purge_threads = 0 innodb_rollback_segments = 128 innodb_lazy_drop_table = 0 log_slow_verbosity = full innodb_adaptive_hash_index_partitions = 1 userstat = 1 query_cache_type = 1 concurrent_insert = 1 query_cache_limit = 1048576 query_cache_min_res_unit = 1K log-slow-admin-statements innodb_stats_on_metadata = OFF innodb_flush_neighbor_pages = 0 innodb_page_size = 16k innodb_file_format = Barracuda innodb_rollback_segment = 16 innodb_adaptive_flushing = 1 innodb_read_ahead = 0 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 100 innodb_spin_wait_delay = 30 default_storage_engine = INNODB innodb_stats_sample_pages = 8 innodb_adaptive_flushing_method = keep_average innodb_stats_update_need_lock = 1 innodb_stats_auto_update = 1 #loose_rpl_semi_sync_master_wait_no_slave = ON #loose_rpl_semi_sync_slave_enabled = ON #loose_rpl_semi_sync_master_trace_level = 1 #loose_rpl_semi_sync_master_timeout = 1000 #loose_rpl_semi_sync_slave_trace_level = 1 #loose_rpl_semi_sync_master_enabled = OFF #loose_ms_consistent_dump_status = 1 flashback-user = flashback flashback-password = flashback5s9248ssdfjJKdsflashback flashback-tool-path = /usr/bin/mysqlbinlog flashback_log_path = /home/mysql/data3054/mysql/flashback.log flashback_mysql_path = /usr/bin/mysql net_read_timeout = 14400 default_week_format = 0 innodb_old_blocks_time = 0 loose_force_memory_to_innodb = 1 loose_rds_max_tmp_disk_space = 107374182400 delay_key_write = ON key_cache_division_limit = 100 innodb_old_blocks_pct = 37 innodb_stats_method = nulls_equal ft_query_expansion_limit = 20 group_concat_max_len = 1024 innodb_read_ahead_threshold = 56 table_open_cache = 2048 log_queries_not_using_indexes = OFF query_cache_size = 0 implicit_primary_key = 1 delayed_insert_timeout = 300 connect_timeout = 120 key_cache_block_size = 1024 innodb_open_files = 300 innodb_purge_batch_size = 20 div_precision_increment = 4 net_retry_count = 10 low_priority_updates = 0 rdsadmin_acl = 268468864 autocommit = 1 slow_launch_time = 2 query_prealloc_size = 8192 loose_rds_set_connection_id_enabled = ON innodb_thread_sleep_delay = 10000 key_cache_age_threshold = 300 innodb_concurrency_tickets = 500 table_definition_cache = 512 innodb_use_native_aio = 0 sql_mode = '' delayed_insert_limit = 100 innodb_table_locks = ON innodb_strict_mode = OFF net_write_timeout = 14400 slave_exec_mode = smart query_alloc_block_size = 8192 delayed_queue_size = 1000 innodb_large_prefix = 0 [mysqldump] quick max_allowed_packet = 64M [mysql] no-auto-rehash prompt = "\\u@\\h : \\d \\R:\\m:\\s> " [myisamchk] key_buffer = 512M sort_buffer_size = 512M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open_files_limit = 8192 user = mysql
|
|