[mariadb]
# InnoDB basics
innodb_file_per_table=1
innodb_thread_concurrency=0
innodb_strict_mode=1

# Memory (fit into a 4GB container safely)
innodb_buffer_pool_size=2G
innodb_buffer_pool_instances=2

# Redo / durability
innodb_log_file_size=512M
innodb_log_buffer_size=64M
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_log_write_ahead_size=128K

# Disable query cache (WP usually worse with it)
query_cache_type=0
query_cache_size=0

# Temp tables
tmp_table_size=64M
max_heap_table_size=64M

# Connections / packets
max_connections=150
max_allowed_packet=128M

# Per-connection buffers (avoid RAM spikes)
sort_buffer_size=2M
join_buffer_size=2M
innodb_sort_buffer_size=2M

# Container/network sanity
skip-name-resolve
thread_cache_size=100

# Your existing choices
performance-schema=0
sql-mode="NO_ENGINE_SUBSTITUTION"
disable_log_bin
local-infile=0