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