64 lines
2.2 KiB
Plaintext
64 lines
2.2 KiB
Plaintext
|
# $FreeBSD: head/databases/mysql80-server/files/my.cnf.sample.in 469734 2018-05-12 15:35:25Z mmokhi $
|
||
|
|
|
||
|
|
[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 = /usr/local
|
||
|
|
datadir = /var/db/mysql
|
||
|
|
tmpdir = /var/db/mysql_tmpdir
|
||
|
|
slave-load-tmpdir = /var/db/mysql_tmpdir
|
||
|
|
secure-file-priv = /var/db/mysql_secure
|
||
|
|
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
|
||
|
|
default_password_lifetime = 0
|
||
|
|
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
|
||
|
|
long_query_time = 0.5
|
||
|
|
innodb_buffer_pool_size = 1G
|
||
|
|
innodb_data_home_dir = /var/db/mysql
|
||
|
|
innodb_log_group_home_dir = /var/db/mysql
|
||
|
|
innodb_data_file_path = ibdata1:128M:autoextend
|
||
|
|
innodb_temp_data_file_path = ibtmp1: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
|
||
|
|
default_authentication_plugin = mysql_native_password
|
||
|
|
|
||
|
|
[mysqldump]
|
||
|
|
max_allowed_packet = 256M
|
||
|
|
quote_names
|
||
|
|
quick
|