mysql配置⽂件模板_MySQL配置⽂件模板[mysqld]
####:forglobal
user=jianglexing # mysql
basedir=/usr/local/mysql # /usr/local/mysql/datadir=/usr/local/mysql/data # /usr/local/mysql/data
server_id=1 # 0port=3306 # 3306socket=/tmp/mysql.sock # /tmp/mysql.sock
auto_increment_increment=1 # 1auto_increment_offset=1 # 1lower_case_table_names=1 # 0secure_file_priv= # null####:forbinlog
binlog_format=row # row
log_bin=mysql-bin # off
binlog_rows_query_log_events=on # off
log_slave_updates=on # off
expire_logs_days=4 # 0binlog_cache_size=32768 # 32768(32k)
binlog_checksum=none # CRC32
sync_binlog=1 # 1####:for error-log
log_error=mysql-err.log # /usr/local/mysql/data/
####:forslow query log
####:forgtid
gtid_mode=on # off
enforce_gtid_consistency=on # off
####:forreplication
master_info_repository=table # filerelay_log_info_repository=table # file####:forgroup replication
transaction_write_set_extraction=XXHASH64 # off
loose-group_replication_group_name ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"#
loose-group_replication_start_on_boot =off # off
loose-group_replication_local_address ="127.0.0.1:24901"#
loose-group_replication_group_seeds ="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"loose-
group_replication_bootstrap_group =off # off
####:forinnodb
default_storage_engine=innodb # innodb
default_tmp_storage_engine=innodb # innodb
mysql文档手机版innodb_data_file_path=ibdata1:12M:autoextend # ibdata1:12M:autoextend
innodb_temp_data_file_path=ibtmp1:12M:autoextend # ibtmp1:12M:autoextend
innodb_log_group_home_dir=./ # ./innodb_log_files_in_group=2 # 2innodb_log_file_size=48M # 50331648(48M)
innodb_file_format=Barracuda # Barracuda
innodb_file_per_table=on # on
innodb_page_size=16k # 16384(16k)
innodb_thread_concurrency=0 # 0innodb_read_io_threads=4 # 4innodb_write_io_threads=4 # 4innodb_purge_threads=4 # 4innodb_print_all_deadlocks=on # off
innodb_deadlock_detect=on # on
innodb_lock_wait_timeout=50 # 50innodb_spin_wait_delay=6 # 6innodb_autoinc_lock_mode=2 #
1innodb_stats_persistent=on # on
innodb_stats_persistent_sample_pages=20 # 20innodb_adaptive_hash_index=on # on
innodb_change_buffering=all # all
innodb_change_buffer_max_size=25 # 25innodb_flush_neighbors=1 # 1innodb_flush_method=O_DIRECT #
innodb_doublewrite=on # on
innodb_log_buffer_size=16M # 16777216(16M)
innodb_flush_log_at_timeout=1 # 1innodb_flush_log_at_trx_commit=1 # 1autocommit=1 # 1

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。