Changeset View
Changeset View
Standalone View
Standalone View
head/databases/mysqlwsrep56-server/files/my.cnf.sample.in
Property | Old Value | New Value |
---|---|---|
fbsd:nokeywords | null | yes \ No newline at end of property |
svn:eol-style | null | native \ No newline at end of property |
svn:mime-type | null | text/plain \ No newline at end of property |
# $FreeBSD$ | |||||
[client] | |||||
port = 3306 | |||||
socket = /tmp/mysql.sock | |||||
[mysql] | |||||
prompt = \u@\h [\d]>\_ | |||||
no_auto_rehash | |||||
[mysqld] | |||||
user = mysql | |||||
port = 3306 | |||||
socket = /tmp/mysql.sock | |||||
bind-address = 127.0.0.1 | |||||
basedir = %%PREFIX%% | |||||
datadir = %%MY_DBDIR%% | |||||
tmpdir = %%MY_TMPDIR%% | |||||
slave-load-tmpdir = %%MY_TMPDIR%% | |||||
secure-file-priv = %%MY_SECDIR%% | |||||
log-bin = mysql-bin | |||||
log-output = TABLE | |||||
master-info-repository = TABLE | |||||
relay-log-info-repository = TABLE | |||||
relay-log-recovery = 1 | |||||
slow-query-log = 1 | |||||
server-id = 1 | |||||
sync_binlog = 1 | |||||
sync_relay_log = 1 | |||||
binlog_cache_size = 16M | |||||
expire_logs_days = 30 | |||||
log-slave-updates = 1 | |||||
enforce-gtid-consistency = 1 | |||||
gtid-mode = ON | |||||
safe-user-create = 1 | |||||
lower_case_table_names = 1 | |||||
explicit-defaults-for-timestamp = 1 | |||||
myisam-recover-options = BACKUP,FORCE | |||||
open_files_limit = 32768 | |||||
table_open_cache = 16384 | |||||
table_definition_cache = 8192 | |||||
net_retry_count = 16384 | |||||
key_buffer_size = 256M | |||||
max_allowed_packet = 64M | |||||
query_cache_type = 0 | |||||
query_cache_size = 0 | |||||
long_query_time = 0.5 | |||||
innodb_buffer_pool_size = 1G | |||||
innodb_data_home_dir = %%MY_DBDIR%% | |||||
innodb_log_group_home_dir = %%MY_DBDIR%% | |||||
innodb_data_file_path = ibdata1:128M:autoextend | |||||
innodb_flush_method = O_DIRECT | |||||
innodb_log_file_size = 256M | |||||
innodb_log_buffer_size = 16M | |||||
innodb_write_io_threads = 8 | |||||
innodb_read_io_threads = 8 | |||||
innodb_autoinc_lock_mode = 2 | |||||
skip-symbolic-links | |||||
[mysqldump] | |||||
max_allowed_packet = 256M | |||||
quote_names | |||||
quick |