Skip to content

Instantly share code, notes, and snippets.

@goregrish
Last active April 5, 2021 11:30
Show Gist options
  • Save goregrish/b52bb77dfd69ca13c15f843fecf32d51 to your computer and use it in GitHub Desktop.
Save goregrish/b52bb77dfd69ca13c15f843fecf32d51 to your computer and use it in GitHub Desktop.
Xenforo Database MariaDB my.cnf | handles 15,000 Unique Visitors per day
#
# 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment