# 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]
# port							= 3306 # set in /usr/local/etc/mysql/my.cnf
# socket						= /var/run/mysql/mysql.sock # set in /usr/local/etc/mysql/my.cnf

#FreeBSD defaults
user			= mysql
bind-address	= 127.0.0.1
basedir			= /usr/local
#https://mariadb.com/kb/en/server-system-variables/#net_retry_count
net_retry_count	= 16384

#directory locations
datadir			= /data/db/mysqldata
tmpdir			= /data/db/mysqltemp

#log directory locations
innodb_log_group_home_dir = /data/db/mysqllogs
log-error			= /data/db/mysqllogs/mysql-error.log
slow-query-log-file = /data/db/mysqllogs/mysql-slow.log

#not enabled; but setting to be safe
#audit_log_file			= /data/db/mysqllogs/mysql-audit.log
general_log_file		= /data/db/mysqllogs/mysql-general.log

#for child servers
#relay_log						= /data/db/mysqllogs/mysql-relay-log

#options
character-set-server = utf8
max_connections = 100
max_allowed_packet = 64M

#SQL mode
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#default engine
default_storage_engine = innodb

#binary logging options
log_bin = /data/db/mysqllogs/mysql-bin

#trust function creators
log_bin_trust_function_creators = 1

# binary logging format - mixed recommended
binlog_format = mixed
#log expire
expire_logs_days = 2

#slow query log
slow-query-log = ON
long_query_time = 20

#innodb options
innodb_file_per_table = 1
innodb_default_row_format = dynamic
#only for ZFS systems
innodb_doublewrite		= 0
innodb_flush_method		= O_DSYNC

# [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]