freebsd ayarları

# The MariaDB server
[mysqld]
temp-pool
key_buffer_size=16M
datadir=/my/mysqldata
loose-innodb_file_per_table

[mariadb]
datadir=/my/data
default-storage-engine=aria
loose-mutex-deadlock-detector
max-connections=20

[mariadb-5.5]
language=/my/maria-5.5/sql/share/english/
socket=/tmp/mysql-dbug.sock
port=3307

[mariadb-10.1]
language=/my/maria-10.1/sql/share/english/
socket=/tmp/mysql2-dbug.sock

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
loose-abort-source-on-error

# 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 # inherited from /usr/local/etc/mysql/my.cnf
# socket            = /var/run/mysql/mysql.sock # inherited from /usr/local/etc/mysql/my.cnf
bind-address            = 0.0.0.0
basedir                = /usr/local
datadir                = /var/db/mysql
net_retry_count            = 16384
log_error            = /var/log/mysql/mysqld.err

query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=200
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128

key_buffer=18M
#join_buffer=1M
max_allowed_packet=16M
table_cache=1024
#record_buffer=1M
#sort_buffer_size=18M
#read_buffer_size=18M
max_connect_errors=10
thread_concurrency=2
#myisam_sort_buffer_size=64M
#server-id=1








# [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 `mariadb_safe`
# Renamed from [mysqld_safe] starting with MariaDB 10.4.6.
[mariadb-safe]

err-log=/var/log/mysqld.log
open_files_limit=8192

[mariadb-dump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[mariadb-hotcopy]
interactive-timeout

#safe-updates



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