Attachment 215774 Details for Bug 247413 – mariadb server.cnf

mariadb server.cnf

server.cnf (text/plain), 2.93 KB, created by Henrik Hudson on 2020-06-19 12:19:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Henrik Hudson

Created: 2020-06-19 12:19:45 UTC

Size: 2.93 KB

patch

obsolete

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

Actions: View

Attachments on bug 247413: 215774 | 217213 | 217225 | 218855