summaryrefslogtreecommitdiff
path: root/databases/mariadb1011-server/files/server.cnf.sample.in
blob: cdd9478e1243f475aa4c4081d2e2fd29a57106f3 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
# Options specific to server applications, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#server-option-groups

# Options specific to all server programs
[server]

# Options specific to MariaDB server programs
[server-mariadb]

#
# Options for specific server tools
#

[mysqld]
user				= %%MARIADB_USER%%
# port				= 3306 # inherited from %%ETCDIR%%/my.cnf
# socket			= %%MARIADB_RUNDIR%%/mysql.sock # inherited from %%ETCDIR%%/my.cnf
bind-address			= 127.0.0.1
basedir				= %%PREFIX%%
# datadir			= %%MARIADB_DBDIR%% # --db_dir is set from rc.d
net_retry_count			= 16384
log_error			= %%MARIADB_LOGDIR%%/mysqld.err
# [mysqld] configuration for ZFS
# From https://www.percona.com/resources/technical-presentations/zfs-mysql-percona-technical-webinar
# Create separate datasets for data and logs, eg
# zroot/mysql      compression=on recordsize=128k atime=off
# zroot/mysql/data recordsize=16k
# zroot/mysql/logs
# datadir 			= %%MARIADB_DBDIR%%/data
# innodb_log_group_home_dir	= %%MARIADB_DBDIR%%/log
# audit_log_file		= %%MARIADB_DBDIR%%/log/audit.log
# general_log_file		= %%MARIADB_DBDIR%%/log/general.log
# log_bin			= %%MARIADB_DBDIR%%/log/mysql-bin
# relay_log			= %%MARIADB_DBDIR%%/log/relay-log
# slow_query_log_file		= %%MARIADB_DBDIR%%/log/slow.log
# innodb_doublewrite		= 0
# innodb_flush_method		= O_DSYNC

# Options read by `mariadb_safe`
# Renamed from [mysqld_safe] starting with MariaDB 10.4.6.
[mariadb-safe]

# Options read my `mariabackup`
[mariabackup]

# Options read by `mysql_upgrade`
# Renamed from [mysql_upgrade] starting with MariaDB 10.4.6.
[mariadb-upgrade]

# Specific options read by the mariabackup SST method
[sst]

# Options read by `mysqlbinlog`
# Renamed from [mysqlbinlog] starting with MariaDB 10.4.6.
[mariadb-binlog]

# Options read by `mysqladmin`
# Renamed from [mysqladmin] starting with MariaDB 10.4.6.
[mariadb-admin]