Skip to content

Instantly share code, notes, and snippets.

@Sanne
Created September 12, 2022 15:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save Sanne/7e321b9fcc9bf02b8b443d9422d51eae to your computer and use it in GitHub Desktop.
Save Sanne/7e321b9fcc9bf02b8b443d9422d51eae to your computer and use it in GitHub Desktop.
MySQL configuration for testing
#
# MariaDB tuning meant for fast integration test execution:
# data is meant to be lost. Never use for actual database needs!
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0
# http://www.percona.com/blog/2008/05/31/dns-achilles-heel-mysql-installation/
skip_name_resolve
skip-name-resolve
max_connections = 10
# Some tuning for tmpfs :
innodb_doublewrite = 0
innodb_use_native_aio = 1
innodb_flush_method = O_DSYNC
innodb_log_file_size = 2M
innodb_log_buffer_size = 2M
innodb_buffer_pool_size = 5242880
innodb_file_per_table = 0
innodb_flush_log_at_trx_commit = 0
sync_binlog = 0
innodb_fast_shutdown = 1
innodb_temp_data_file_path = ibtmp1:2M:autoextend:max:32M
# Generally useful for tests:
default-time-zone='+00:00'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
sql-mode="traditional"
strict_password_validation = 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment