Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
44 lines (44 sloc) 1.05 KB
#
[mysqld_safe]
flush_caches = 1
#
[mysqld]
binlog_format = ROW
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
datadir = /var/lib/mysql
default_storage_engine = InnoDB
enforce_gtid_consistency = ON
expire_logs_days = 7
explicit_defaults_for_timestamp
gtid_mode = ON
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_dump_at_shutdown = 0
innodb_buffer_pool_load_at_startup = 0
innodb_buffer_pool_size = 64M
innodb_data_file_path = ibdata1:16M:autoextend:max:128M
innodb_file_per_table
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_log_file_size = 16M
innodb_print_all_deadlocks = 1
log-bin = mysqld-bin
log-error = /var/log/mysql/mysqld.log
max_allowed_packet = 4M
max_connect_errors = 4294967295
max_connections = 16
performance-schema = ON
port = 3306
query_cache_size = 0
query_cache_type = 0
skip-name-resolve
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sync_binlog = 1
thread_cache_size = 16
thread_stack = 128K
tmpdir = /srv/tmp
transaction_isolation = REPEATABLE-READ
user = mysql
wait_timeout = 60
#
server-id = 1
You can’t perform that action at this time.