[mysqld]
symbolic-links=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mariadb/mariadb.pid
general_log_file=/var/log/mariadb/general.log
log-error=/var/log/mariadb/mariadb.log
slow_query_log = 1
slow_query_log_file = /var/log/mariadb/slow_query.log
long_query_time = 5.0
min_examined_row_limit = 100
performance_schema = 1
max_connections = 500
open_files_limit = 65535
query_cache_size = 32M
max_allowed_packet = 64M
default_storage_engine = InnoDB
#innodb_file_format = Barracuda
innodb_strict_mode = 1
innodb_file_per_table = 1
innodb_open_files = 16384
innodb_buffer_pool_size = 512M
innodb_buffer_pool_instances = 4
innodb_log_file_size = 50M
innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2
innodb_flush_log_at_trx_commit = 0
innodb_print_all_deadlocks = 1
table_definition_cache = 3000
table_open_cache = 5000
tmp_table_size = 64M
max_heap_table_size = 64M
read_buffer_size = 1M
sort_buffer_size = 2M
join_buffer_size = 1M
join_cache_level = 6
optimizer_search_depth = 0
optimizer_switch = 'mrr=on,mrr_sort_keys=on,optimize_join_buffer_size=on'
optimizer_use_condition_selectivity = 4
histogram_size = 254
use_stat_tables = preferably
binlog_cache_size = 2M
binlog_format = row
binlog_row_image = MINIMAL
sync_binlog = 0
binlog_commit_wait_count = 100
binlog_commit_wait_usec = 100000
expire_logs_days = 1