# Percona MySQL tuned for Bitrix on a dedicated ~12GB VPS.
# TCP bound to loopback only; production access is via unix socket ('localhost').
[mysqld]
bind-address        = 127.0.0.1
mysqlx-bind-address = 127.0.0.1

innodb_buffer_pool_size      = 4G
innodb_flush_method          = O_DIRECT
innodb_flush_log_at_trx_commit = 1

character-set-server = utf8mb4
collation-server     = utf8mb4_unicode_ci
skip_name_resolve    = 1

max_connections    = 200
thread_cache_size  = 64
tmp_table_size     = 64M
max_heap_table_size = 64M
table_open_cache   = 4000
open_files_limit   = 65535

slow_query_log      = 1
slow_query_log_file = /var/lib/mysql/mysql-slow.log
long_query_time     = 1

performance_schema = ON