XtraDB my.conf
[mysqld]
max_connections=2000
key_buffer_size=200M
low_priority_updates=1
sort_buffer_size = 2097152
table_open_cache = 8000
# files
innodb_file_per_table
innodb_log_group_home_dir=/DATA2/REDO
innodb_log_file_size=128M
# buffers
innodb_buffer_pool_size=8000M
innodb_additional_mem_pool_size=20M
innodb_log_buffer_size=8M
# tune
innodb_checksums=0
innodb_doublewrite=0
innodb_support_xa=0
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit=2
innodb_flush_method= O_DIRECT
innodb_max_dirty_pages_pct=15
### innodb_extra_rsegments=16
# Percona
innodb_io_capacity = 2000
innodb_adaptive_checkpoint = 1
innodb_write_io_threads = 16
innodb_read_io_threads = 16