[client-server]
!includedir /etc/my.cnf.d

[mysqld]
# Logging. Sesuaikan dengan hostname
log-error = /var/lib/mysql/kerinci.iixcp.rumahweb.net.err

# Optional performance tweaks
performance-schema = 0

# Buffer pool
innodb_buffer_pool_size = 4G
innodb_file_per_table = 1

# Koneksi
max_connections = 512
max_allowed_packet = 256M
open_files_limit = 80000
unix_socket = OFF

# Storage engine default
default-storage-engine = InnoDB

# SQL mode
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# Nonaktifkan Query Cache (eliminasi locking & fragmentasi)
query_cache_type = 0
query_cache_size = 0
query_cache_limit = 0
key_buffer_size = 32M  # MyISAM legacy support

# Timeout koneksi idle
wait_timeout = 180
interactive_timeout = 180

# Table caching
table_open_cache = 2048
table_definition_cache = 4096

# max execution time untuk mysql
max_statement_time = 300