[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/home/mysqltmp
tokudb_tmp_dir=/home/mysqltmp
skip-networking
bind-address = 127.0.0.1
innodb                                      = ON

default_storage_engine						= tokudb
key_buffer_size								= 2048M
key_cache_block_size						= 2048M
key_cache_age_threshold						= 500
key_cache_division_limit					= 50
query_cache_size 							= 32
query_cache_limit 							= 128M
max_connections 							= 500
thread_cache_size 							= 10000
query_cache_min_res_unit 					= 0
tmp_table_size 								= 128M
max_heap_table_size 						= 128M
table_definition_cache 						= 16384
concurrent_insert							= 2
max_allowed_packet 							= 500M
net_buffer_length 							= 2K
wait_timeout 								= 300
table_definition_cache 						= 2000
thread-handling 							= pool-of-threads
thread_pool_size 							= 100
key_cache_segments 							= 64
back_log									= 150
table_open_cache 							= 2024

aria_pagecache_buffer_size 					= 536870912
aria_pagecache_age_threshold 				= 400
aria_pagecache_division_limit 				= 90

innodb_thread_concurrency					= 8	#recommend 2x core quantity
innodb_commit_concurrency					= 16	#recommend 4x num disks
innodb_flush_method							= O_DIRECT	   #O_DIRECT = local/DAS, O_DSYNC = SAN/iSCSI
#innodb_buffer_pool_size					= 10G 	#global buffer
innodb_log_file_size 						= 256m
innodb_log_buffer_size						= 4M

## Per-Thread Buffers * (max_connections) = total per-thread mem usage
thread_stack 								= 256K	  #default: 32bit: 192K, 64bit: 256K
sort_buffer_size 							= 1M	  #default: 2M, larger may cause perf issues
read_buffer_size 							= 256k	  #default: 128K, change in increments of 4K
read_rnd_buffer_size 						= 512k	  #default: 256K
join_buffer_size 							= 512K	  #default: 128K
## total per-thread buffer memory usage: 8832000K = 8.625GB

optimizer_switch = "mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on,exists_to_in=on"

deadlock_search_depth_short = 3
deadlock_search_depth_long = 10
deadlock_timeout_long = 10000000
deadlock_timeout_short = 5000

thread_pool_idle_timeout				= 300

# TokuDB Cache should be set to at least half of available RAM
tokudb_cache_size = 9GB
tokudb_row_format = tokudb_lzma
tokudb_directio = OFF
tokudb_empty_scan = disabled
tokudb_read_block_size = 16K
tokudb_commit_sync = ON
tokudb_checkpointing_period = 900
tokudb_block_size = 4M
tokudb_cleaner_iterations = 10000
tokudb_fanout = 128