[server]

[mariadbd]

# -------------------------------------------------------------------------------------------------------------------- #
# BASIC SETTINGS
# -------------------------------------------------------------------------------------------------------------------- #

bind_address = 127.0.0.1
port = 3306
datadir = /var/lib/mysql
skip_name_resolve = on

# -------------------------------------------------------------------------------------------------------------------- #
# FINE TUNING
# -------------------------------------------------------------------------------------------------------------------- #

key_buffer_size = 128M
max_allowed_packet = 1G
max_connections = 100
myisam_recover_options = BACKUP
table_cache = 64
thread_cache_size = 8
thread_stack = 192K

# -------------------------------------------------------------------------------------------------------------------- #
# LOGGING
# -------------------------------------------------------------------------------------------------------------------- #

log_error = /var/log/mysql/error.log
log_slow_query_file = /var/log/mysql/mariadb-slow.log

# -------------------------------------------------------------------------------------------------------------------- #
# CHARACTER SETS
# -------------------------------------------------------------------------------------------------------------------- #

character_set_collations = utf8mb4=uca1400_ai_ci
character_set_server = utf8mb4

# -------------------------------------------------------------------------------------------------------------------- #
# INNODB
# -------------------------------------------------------------------------------------------------------------------- #

innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:2G:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 256M
innodb_log_file_size = 512M