/home/suroeste/public_html/payments.transportessuroeste.com/docker/mysql
Edit: /home/suroeste/public_html/payments.transportessuroeste.com/docker/mysql/my.cnf (1533B)
# ============================================================================
# TRANSPORTES SUROESTE - MySQL/MariaDB Configuration
# ============================================================================
# Optimized for payment gateway workloads
# ============================================================================
[mysqld]
# Character set
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
# Networking
bind-address = 0.0.0.0
port = 3306
max_connections = 100
max_connect_errors = 10
wait_timeout = 600
interactive_timeout = 600
# InnoDB
innodb_buffer_pool_size = 256M
innodb_log_file_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_lock_wait_timeout = 15
# Query cache (disabled for writes-heavy workload)
query_cache_type = 0
query_cache_size = 0
# Logging
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 2
log_queries_not_using_indexes = 0
# General
tmp_table_size = 32M
max_heap_table_size = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
thread_cache_size = 16
# Security
local_infile = 0
symbolic-links = 0
skip-name-resolve = 1
# Event scheduler (for reconciliation and cleanup)
event_scheduler = ON
# SQL mode
sql_mode = STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4