[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 = 12G
innodb_file_per_table = 1

# Koneksi
max_connections = 1024
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 = 60
interactive_timeout = 60

# Table caching
table_open_cache = 4096
table_definition_cache = 4096

# max execution time untuk mysql
max_statement_time = 60

tmp_table_size = 128M
max_heap_table_size = 128M
innodb_stats_on_metadata = 0
innodb_flush_method = O_DIRECT