Xenforo Database MariaDB my.cnf | handles 15,000 Unique Visitors per day

my.cnf

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

# This will be passed to all MariaDB clients
[client]

# The MariaDB server
[mysqld]
# innodb
#page out all data in the InnoDB Buffer Pool prior to redoing the Log Files
innodb_max_dirty_pages_pct = 0
#memory allocated to the InnoDB buffer pool by MySQL
innodb_buffer_pool_size=8G
#25% of the buffer size
innodb_log_file_size = 1G

sort_buffer_size = 1M
join_buffer_size = 1M
read_buffer_size = 1M
max_connections = 100
max_allowed_packet=256M

# Skip reverse DNS lookup
skip-name-resolve

[mariadb]
log_error=/var/log/mariadb.err
slow_query_log = 0
long_query_time = 2
slow_query_log_file = /var/log/slow-query.log
log_queries_not_using_indexes

#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d