my.cnf percona test

percona-my.cnf

[client]
port 						= 3306
socket 						= /var/lib/mysql/mysql.sock

[mysqld]
server-id 					= 1
port 						= 3306
datadir						= /var/lib/mysql
socket						= /var/lib/mysql/mysql.sock
pid-file					= /var/run/mysqld/mysqld.pid
old_passwords					= 1
max_connections 				= 4096
skip-secure-auth
old_passwords					= 1
secure_auth					= 0

myisam_sort_buffer_size 			= 64M
key_buffer_size 				= 256M
join_buffer_size 				= 4M
read_buffer_size 				= 4M
read_rnd_buffer_size 				= 4M
sort_buffer_size 				= 32M
table_open_cache 				= 8192
thread_cache_size 				= 512

wait_timeout 					= 28800
interactive_timeout 				= 150
connect_timeout 				= 60

tmp_table_size 					= 512M
max_heap_table_size 				= 512M
max_allowed_packet 				= 1024M
max_connect_errors 				= 999999999

query_cache_limit 				= 8M
query_cache_size 				= 128M
query_cache_type 				= 1
query_prealloc_size 				= 16384
query_alloc_block_size 				= 16384

tmpdir = /tmp
skip-name-resolve

##Slow Query Log
#set-variable					= long_query_time=3
#log-long-format
#log-slow-queries				= /var/log/mysqld.slow.log

##innoDB
innodb_thread_concurrency 			= 24
innodb_buffer_pool_size 			= 26G
innodb_log_file_size 				= 384M
innodb_log_buffer_size				= 24M
innodb_additional_mem_pool_size 		= 16M
innodb_io_capacity 				= 800
innodb_concurrency_tickets 			= 900
innodb_lock_wait_timeout			= 75
innodb_flush_method				= O_DIRECT

## 1 is the safest value here, 0 is higher performance but you 
## can lose up to 1 second of transaction in a crash
innodb_flush_log_at_trx_commit			= 1

[mysqld_safe]
log-error					= /var/log/mysqld.log
pid-file					= /var/run/mysqld/mysqld.pid

[mysqldump]
quick

[myisamchk]
key_buffer_size					= 128M
sort_buffer_size 				= 128M
read_buffer_size 				= 2M
write_buffer_size 				= 2M

[mysqlhotcopy]
interactive-timeout