# Add to my.ini / my.cnf under [mysqld] then restart MySQL (XAMPP: stop/start MySQL)
# These values suit a typical 4–8 GB RAM hospital PC running XAMPP.

innodb_buffer_pool_size = 512M
innodb_log_file_size = 128M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = normal
tmp_table_size = 64M
max_heap_table_size = 64M
sort_buffer_size = 2M
join_buffer_size = 2M
table_open_cache = 400
thread_cache_size = 16
query_cache_type = 0
query_cache_size = 0

# PHP (php.ini)
opcache.enable=1
opcache.memory_consumption=128
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=10000
opcache.validate_timestamps=1
opcache.revalidate_freq=60
realpath_cache_size=4096K
realpath_cache_ttl=600
memory_limit=256M
max_execution_time=120
