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