[mysqld_safe]
nice 				= -15

[mysqld]
max_binlog_size 		= 256M	  #max size for binlog before rolling
expire_logs_days 		= 1	#binlog files older than this will be purged

## 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 		= 1M	  #default: 128K, change in increments of 4K
read_rnd_buffer_size 	        = 1M	  #default: 256K				
join_buffer_size 		= 1M	  #default: 128K
binlog_cache_size 		= 64K	  #default: 32K, size of buffer to hold TX queries

## Query Cache
query_cache_size 		= 32M     #global buffer
query_cache_limit 		= 512K	  #max query result size to put in cache

## Connections
max_connections 		= 2000	  #multiplier for memory usage via per-thread buffers
max_connect_errors 		= 100	  #default: 10
concurrent_insert		= 2	      #default: 1, 2: enable insert for all instances
connect_timeout			= 30	  #default -5.1.22: 5, +5.1.22: 10

## Table and TMP settings
max_heap_table_size 		= 1G	#recommend same size as tmp_table_size
bulk_insert_buffer_size 	= 1G	#recommend same size as tmp_table_size
tmp_table_size                  = 1G    #recommend 1G min

# set tmpdir to a ramdisk?
#tmpdir                         = /data/mysql-tmp0:/data/mysql-tmp1

## Thread settings
thread_concurrency		= 0  	#recommend 2x CPU cores [0 create as many as needed]
thread_cache_size		= 100 	#recommend 5% of max_connections

## MyISAM Engine
key_buffer			= 1M	#global buffer
myisam_sort_buffer_size		= 128M	#index buffer size for creating/altering indexes
myisam_max_sort_file_size	= 256M	#max file size for tmp table when creating/alering indexes

## InnoDB IO settings -  5.5.x and greater
innodb_write_io_threads 	= 16
innodb_read_io_threads		= 16

## InnoDB Plugin Independent Settings
innodb_file_per_table		#enable always
innodb_data_file_path		= ibdata1:128M;ibdata2:10M:autoextend
innodb_buffer_pool_size		= 12G 			#global buffer
innodb_additional_mem_pool_size	= 4M			#global buffer
innodb_flush_log_at_trx_commit	= 0				#2/0 = perf, 1 = ACID
innodb_log_file_size 		= 256M
innodb_log_buffer_size 		= 128M 			#global buffer
innodb_lock_wait_timeout 	= 300	
innodb_thread_concurrency	= 16			#recommend 2x core quantity
innodb_commit_concurrency	= 16			#recommend 4x num disks
innodb_flush_method		= O_DSYNC	    #O_DIRECT = local/DAS, O_DSYNC = SAN/iSCSI
innodb_support_xa		= 0		   		#recommend 0, disable xa to negate extra disk flush
skip-innodb-doublewrite
sync_binlog			= 0