InnoDB 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_file_io_threads=16
innodb_flush_log_at_trx_commit=2
innodb_flush_method= O_DIRECT
innodb_max_dirty_pages_pct=15