_memory=<<<{SERVER:K=[MEMORY]/2}{DEDICATED:K=[MEMORY]*90/100}{:MK=[MEMORY]/12,48M}>>>
_myisam_pct=<<<{MYISAM:=100}{INNODB:=5}{USERDEF_DB:=[myisam_pct]}{:=50}>>>
_active_connections=<<<{DSS:=20}{OLTP:=500}{:=[active_connections]}>>>
_over_commit_factor=<<<{:=10}>>>
_over_commit_factor2=<<<{:=10}>>>
[client]
<<ifdef SKIPNETWORKING>>
pipe
socket=mysql
<<else>>
port=<<{:=[port]}>>
<<endif>>
[mysql]
default-character-set=<<{:[default-character-set]}>>
[mysqld]
<<ifdef SKIPNETWORKING>>
skip-networking
enable-named-pipe
socket=mysql
<<else>>
port=<<{:=[port]}>>
<<endif>>
basedir=<<{:[basedir]}>>
datadir=<<{:[datadir]}>>
default-character-set=<<{:[default-character-set]}>>
default-storage-engine=<<{MIXED|INNODB:INNODB}{:MYISAM}>>
<<ifdef STRICTMODE>>
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
<<endif>>
_max_connections=<<<{:Rm=([_active_connections]*3)/2+10,[_memory]/512K}>>>
max_connections=<<{:RM=100,[_max_connections]}>>
_available_memory=<<<{:=[_memory]-[max_connections]*256K}>>>
query_cache_size=<<{DSS:=0}{:KM=[_available_memory]/10,8M}>>
_available_memory=<<<{:=[_available_memory]-[query_cache_size]}>>>
_buffers_memory=<<<{:=([_available_memory]*7)/10}>>>
_thread_buffers_memory=<<<{:=([_available_memory]*3)/10}>>>
_memory_per_thread=<<<{:=[_thread_buffers_memory]*[_over_commit_factor]/[max_connections]}>>>
table_cache=<<{:RM=256,[max_connections]*2}>>
_buffers_memory=<<<{:=[_buffers_memory]-[table_cache]*8K}>>>
_big_thread_buffers=<<<{:=[_memory_per_thread]*[_over_commit_factor2]}>>>
_tmp_table_size=<<<{:KM=16M,[_big_thread_buffers]}>>>
tmp_table_size=<<{:Km=[_tmp_table_size],[_memory]*10/100}>>
_thread_cache=<<<{:M=([max_connections]*5)/100,8}>>>
thread_cache_size=<<{:Rm=[_thread_cache],64}>>
_myisam_buffers=<<<{:=[_buffers_memory]*([_myisam_pct]/100)}>>>
myisam_max_sort_file_size=<<{DEDICATED|SHARED:K=100G}{:K=100G}>>
myisam_max_extra_sort_file_size=<<{DEDICATED|SHARED:K=100G}{:K=100G}>>
_myisam_sort_buffer_size=<<<{:KM=8M,[_big_thread_buffers]}>>>
myisam_sort_buffer_size=<<{:Km=[_myisam_sort_buffer_size],[_memory]*20/100}>>
key_buffer_size=<<{:KM=8M,[_myisam_buffers]/2}>>
read_buffer_size=<<{:Km=64K,([_memory_per_thread]*2)/10,[_memory]/100}>>
read_rnd_buffer_size=<<{:Km=256K,([_memory_per_thread]*4)/10,[_memory]*4/100}>>
_sort_buffer_size=<<<{:Km=256K,([_memory_per_thread]*3)/10}>>>
sort_buffer_size=<<{:Km=[_sort_buffer_size],[_memory]*2/100}>>
<<{SETINNODBHOMEDIR:[innodb_home]}{:}>>
_innodb_buffers=<<<{:=[_buffers_memory]*(1-[_myisam_pct]/100)}>>>
<<{MYISAM:skip-innodb}{:#skip-innodb}>>
_innodb_additional_mem_pool_size=<<<{:M=2M,([_innodb_buffers]*2)/100}>>>
innodb_additional_mem_pool_size=<<{:Km=32M,[_innodb_additional_mem_pool_size]}>>
_innodb_buffers=<<<{:M=[_innodb_buffers]-[innodb_additional_mem_pool_size],0}>>>
innodb_flush_log_at_trx_commit=1
_innodb_log_buffer_size=<<<{:M=1M,[_innodb_buffers]/100}>>>
innodb_log_buffer_size=<<{:Km=16M,[_innodb_log_buffer_size]}>>
innodb_buffer_pool_size=<<{:MK=[_innodb_buffers]-[innodb_log_buffer_size],8M}>>
_innodb_log_file_size=<<<{OLTP:Rm=([innodb_buffer_pool_size]*2)/10,1G}{DSS:Rm=([innodb_buffer_pool_size]*5)/10,1G}{:Rm=([innodb_buffer_pool_size]*2)/10,1G}>>>
innodb_log_file_size=<<{CONFIG_ALTERED:[old_innodb_log_file_size]}{:KM=10M,[_innodb_log_file_size]}>>
innodb_thread_concurrency=<<{:M=8,2*([CPUS]+[DISKS])}>>
innodb_thread_concurrency=<<{:M=8,2*([CPUS]+1)}>>
