[mysqld]
disable-log-bin=1
default-authentication-plugin=mysql_native_password
innodb_file_per_table=1
performance-schema=0
mysqlx=0
max_allowed_packet=268435456
# --- InnoDB Performance ---
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 1G
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
# --- Temp Table Performance ---
tmp_table_size = 512M
max_heap_table_size = 512M
# --- File/Cache ---
table_open_cache = 4000
table_definition_cache = 4000
open_files_limit = 65535
All system for education purposes only. For more tools: Telegram @jackleet