You've already forked percona
70 lines
2.6 KiB
Django/Jinja
70 lines
2.6 KiB
Django/Jinja
[mysqld]
|
|
# Network settings
|
|
bind-address = {{ percona_bind_address }}
|
|
port = {{ percona_port }}
|
|
|
|
# Character set and collation
|
|
character-set-server = utf8mb4
|
|
collation-server = utf8mb4_general_ci
|
|
|
|
# Connection settings
|
|
max_connections = {{ percona_max_connections }}
|
|
max_connect_errors = {{ percona_max_connect_errors }}
|
|
connect_timeout = {{ percona_connect_timeout }}
|
|
wait_timeout = {{ percona_wait_timeout }}
|
|
interactive_timeout = {{ percona_interactive_timeout }}
|
|
|
|
# Buffer settings
|
|
max_allowed_packet = {{ percona_max_allowed_packet }}
|
|
sort_buffer_size = {{ percona_sort_buffer_size }}
|
|
read_buffer_size = {{ percona_read_buffer_size }}
|
|
read_rnd_buffer_size = {{ percona_read_rnd_buffer_size }}
|
|
join_buffer_size = {{ percona_join_buffer_size }}
|
|
thread_cache_size = {{ percona_thread_cache_size }}
|
|
table_open_cache = {{ percona_table_open_cache }}
|
|
table_definition_cache = {{ percona_table_definition_cache }}
|
|
|
|
# InnoDB settings
|
|
innodb_buffer_pool_size = {{ percona_innodb_buffer_pool_size }}
|
|
innodb_buffer_pool_instances = {{ percona_innodb_buffer_pool_instances }}
|
|
innodb_log_file_size = {{ percona_innodb_log_file_size }}
|
|
innodb_log_buffer_size = {{ percona_innodb_log_buffer_size }}
|
|
innodb_flush_log_at_trx_commit = {{ percona_innodb_flush_log_at_trx_commit }}
|
|
innodb_flush_method = {{ percona_innodb_flush_method }}
|
|
innodb_file_per_table = {{ percona_innodb_file_per_table }}
|
|
innodb_io_capacity = {{ percona_innodb_io_capacity }}
|
|
innodb_io_capacity_max = {{ percona_innodb_io_capacity_max }}
|
|
innodb_thread_concurrency = {{ percona_innodb_thread_concurrency }}
|
|
innodb_read_io_threads = {{ percona_innodb_read_io_threads }}
|
|
innodb_write_io_threads = {{ percona_innodb_write_io_threads }}
|
|
innodb_open_files = {{ percona_innodb_open_files }}
|
|
|
|
# Binary logging
|
|
log_bin = {{ percona_log_bin }}
|
|
binlog_format = {{ percona_binlog_format }}
|
|
binlog_expire_logs_seconds = {{ percona_binlog_expire_logs_seconds }}
|
|
max_binlog_size = {{ percona_max_binlog_size }}
|
|
sync_binlog = {{ percona_sync_binlog }}
|
|
|
|
# Logging
|
|
log_error = {{ percona_log_error }}
|
|
slow_query_log = {{ percona_slow_query_log }}
|
|
slow_query_log_file = {{ percona_slow_query_log_file }}
|
|
long_query_time = {{ percona_long_query_time }}
|
|
log_queries_not_using_indexes = {{ percona_log_queries_not_using_indexes }}
|
|
|
|
# Replication settings
|
|
server_id = {{ percona_server_id }}
|
|
gtid_mode = {{ percona_gtid_mode }}
|
|
enforce_gtid_consistency = {{ percona_enforce_gtid_consistency }}
|
|
log_slave_updates = {{ percona_log_slave_updates }}
|
|
|
|
# Performance schema
|
|
performance_schema = {{ percona_performance_schema }}
|
|
|
|
# SQL modes
|
|
sql_mode = {{ percona_sql_mode }}
|
|
|
|
# Authentication
|
|
mysql_native_password = ON
|