1[client] 2port = 3306 3socket = /tmp/mysql.sock 4 5[mysql] 6prompt = \u@\h [\d]>\_ 7no_auto_rehash 8 9[mysqld] 10user = mysql 11port = 3306 12socket = /tmp/mysql.sock 13bind-address = 127.0.0.1 14basedir = %%PREFIX%% 15datadir = %%MY_DBDIR%% 16tmpdir = %%MY_TMPDIR%% 17replica-load-tmpdir = %%MY_TMPDIR%% 18secure-file-priv = %%MY_SECDIR%% 19log-bin = mysql-bin 20log-output = TABLE 21relay-log-recovery = 1 22slow-query-log = 1 23server-id = 1 24sync_binlog = 1 25sync_relay_log = 1 26binlog_cache_size = 16M 27binlog_expire_logs_seconds = 2592000 28default_password_lifetime = 0 29enforce-gtid-consistency = 1 30gtid-mode = ON 31safe-user-create = 1 32lower_case_table_names = 1 33explicit-defaults-for-timestamp = 1 34myisam-recover-options = BACKUP,FORCE 35open_files_limit = 32768 36table_open_cache = 16384 37table_definition_cache = 8192 38net_retry_count = 16384 39key_buffer_size = 256M 40max_allowed_packet = 64M 41long_query_time = 0.5 42innodb_buffer_pool_size = 1G 43innodb_data_home_dir = %%MY_DBDIR%% 44innodb_log_group_home_dir = %%MY_DBDIR%% 45innodb_data_file_path = ibdata1:128M:autoextend 46innodb_temp_data_file_path = ibtmp1:128M:autoextend 47innodb_flush_method = O_DIRECT 48innodb_redo_log_capacity = 512M 49innodb_log_buffer_size = 16M 50innodb_write_io_threads = 8 51innodb_read_io_threads = 8 52innodb_autoinc_lock_mode = 2 53 54[mysqldump] 55max_allowed_packet = 256M 56quote_names 57quick 58