aboutsummaryrefslogtreecommitdiff
path: root/databases/mariadb104-server/files/server.cnf.sample.in
blob: c49de469ce1e99f192af42c64e4795deb19fa7a3 (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
# 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				= mysql
# port				= 3306 # set in %%ETCDIR%%/my.cnf
# socket			= /var/run/mysql/mysql.sock # set in %%ETCDIR%%/my.cnf
bind-address			= 127.0.0.1
basedir				= %%PREFIX%%
datadir				= /var/db/mysql
net_retry_count			= 16384
# [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 			= /var/db/mysql/data
# innodb_log_group_home_dir	= /var/db/mysql/log
# audit_log_file		= /var/db/mysql/log/audit.log
# general_log_file		= /var/db/mysql/log/general.log
# log_bin			= /var/db/mysql/log/mysql-bin
# relay_log			= /var/db/mysql/log/relay-log
# slow_query_log_file		= /var/db/mysql/log/slow.log
# innodb_doublewrite		= 0
# innodb_flush_method		= O_DSYNC

# Options read by `mysqld_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]