Skip to content

Instantly share code, notes, and snippets.

@harryge00
Created June 24, 2020 03:25
Show Gist options
  • Save harryge00/aad66f51ebf05e04d7e5cfff78309ee7 to your computer and use it in GitHub Desktop.
Save harryge00/aad66f51ebf05e04d7e5cfff78309ee7 to your computer and use it in GitHub Desktop.
my.cnf for linktime mysql
[mysqld]
port = 3306
back_log = 3000
character_set_server = utf8
max_connect_errors = 100
max_connections = 2000
max_user_connections = 2000
max_heap_table_size = 64M
max_allowed_packet = 1024M
max_binlog_size = 500M
net_buffer_length = 16K
transaction_isolation = READ-COMMITTED
skip_name_resolve
lower_case_table_names = 1
log-bin =mysqld-bin
log-bin-index = master-log-bin.index
relay-log = relay-mysqld-bin
relay-log-info-file =slave-relay-log.info
relay-log-index = slave-relay-log.index
master-info-file = master.info
log-slave-updates = 1
sync_binlog = 1
slow_query_log_file = slow_query.log
slow_query_log = 1
binlog_format = ROW
innodb_data_file_path = ibdata1:200M:autoextend
innodb_file_per_table
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 = 50
innodb_doublewrite = 1
innodb_rollback_on_timeout = OFF
innodb_autoinc_lock_mode = 1
innodb_io_capacity = 2000
innodb_purge_threads = 1
innodb_stats_on_metadata = OFF
innodb_file_format = Barracuda
default_storage_engine = InnoDB
innodb_stats_sample_pages = 8
open_files_limit = 65535
autocommit = 1
innodb_table_locks = ON
innodb_open_files = 300
innodb_strict_mode = OFF
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
gtid_mode=on
enforce_gtid_consistency=on
report_port=3306
master-info-repository = TABLE
relay-log-info-repository = TABLE
skip_slave_start=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment