my.ini - whats yours look like?

[oldfox303]

G'day,
I'm setting up a local MySQL database for my Reality DayZ server. i have only used GSP's or a local server with a remote DB previously.
I followed the setup suggestions here, but looking at the my.ini files of other server packages that have mysql bundled i feel my setup is really bloated.
I am installing this on my clan's server which has really good specs but has a few other games running on it so I'm trying not to hog resources, despite there currently being plenty of capacity.
Here is the my.ini file that I generated (minus comments):

[client]
port=3306
 
[mysql]
default-character-set=utf8
 
[mysqld]
port=3306
basedir="C:/XXXX"
datadir="C:/XXXX"
character-set-server=utf8
 
default-storage-engine=INNODB
 
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=205M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=410M
key_buffer_size=36M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
 
innodb_data_home_dir="C:/XXXX"
 
innodb_additional_mem_pool_size=27M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=14M
innodb_buffer_pool_size=1304M
innodb_log_file_size=652M
innodb_thread_concurrency=18

I'm really hoping you guys can share your config and/or have some constructive suggestions.

Cheers,

OldfOx

 

[lport3]

These settings are of course very important. It was the case, I have set up their own.

[client]
no-beep
port=3306
 
[mysql]
default-character-set=utf8
# server_type=3
 
[mysqld]
port=3306
 
# basedir="C:\Program Files\MySQL\MySQL Server 5.6\"
# datadir="C:\ProgramData\MySQL\MySQL Server 5.6\data\"
character-set-server=utf8
default-storage-engine=INNODB
 
lower_case_table_names=0
 
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 
low-priority-updates
skip-external-locking
 
log-output=NONE
general-log=0
general_log_file="LPORT3-WK-NB.log"
slow-query-log=0
slow_query_log_file="LPORT3-WK-NB-slow.log"
long_query_time=10
 
log-error="LPORT3-WK-NB.err"
 
max_connections=10000
 
query_cache_size=512M
query_cache_type=ON
 
table_open_cache=2000
tmp_table_size=1G
max_heap_table_size = 64M
thread_cache_size=64
 
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=160M
 
key_buffer_size=2G
 
read_buffer_size=64K
read_rnd_buffer_size=64K
sort_buffer_size=128K
 
innodb_buffer_pool_size=1G
innodb_log_file_size=512M
innodb_log_buffer_size=8M
 
innodb_flush_log_at_trx_commit=0
 
innodb_thread_concurrency=4
innodb_buffer_pool_instances=8
 
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=10000
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
 
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000

innodb_flush_log_at_trx_commit=0// faster than 1, but can be a problem with saving (fortunately rare)