File: /srv/data/.config/mysql-5.7/my.cnf
!include /srv/data/.current_db/base/my.cnf
# The MySQL server
[mysqld]
# * Fine Tuning
key_buffer_size = 16M
max_allowed_packet = 32M
table_open_cache = 64
sort_buffer_size = 1M
join_buffer_size = 1M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_stack = 256k
thread_cache_size = 8
net_buffer_length = 8K
max_connections = 32
# * Query Cache Configuration
query_cache_limit = 64k
query_cache_size = 2M
# * InnoDB
innodb_buffer_pool_size = 64M
# we don't fsync() logs so we can have a smaller buffer
innodb_log_buffer_size = 512k
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 4