[client]
port=3309
[mysqld]
port=3309
basedir=D:/HPC Tech/MySQL/Engine
datadir=D:/HPC Tech/MySQL/Data
tmpdir=D:/HPC Tech/MySQL/tmpdir
default_storage_engine=myisam
character-set-server=utf8
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
#table_cache=8192
tmp_table_size=16G
thread_cache_size=16
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=4G
key_buffer_size=256M
read_buffer_size=256M
read_rnd_buffer_size=1G
sort_buffer_size=4G
#innodb_additional_mem_pool_size=256M
innodb_flush_log_at_trx_commit=1
innodb_buffer_pool_size=2G
innodb_thread_concurrency=8
innodb_flush_method=normal
query_cache_limit=4G
query_cache_size=4G
query_cache_type=2
#log-slow-queries=slow
log-queries-not-using-indexes
innodb_log_buffer_size=100M
innodb_file_per_table
max_allowed_packet=2G
max_heap_table_size=2G

# This is crucial to avoid checkpointing all the time:
innodb_log_file_size=512M

# If you have control on who consumes the DB, and you don't use hostnames when you've set up permissions - this can help as well.
skip_name_resolve
