svfes2 my.cnf

my.cnf

[mysqld]
datadir=/fioa/mysql
user=mysql
max_connections = 1000
thread_cache_size = 1000
sort_buffer_size=2M

#innodb_buffer_pool_size = 27G
#innodb_buffer_pool_size = 27000M
innodb_buffer_pool_size = 28150M

skip-name-resolve
innodb_flush_method=O_DIRECT
innodb_write_io_threads = 16
innodb_read_io_threads = 16
innodb_io_capacity=20000
socket=/fioa/mysql/mysql.sock

sync_binlog = 0

#innodb_file_per_table # already default
innodb_log_file_size=4G
innodb_log_files_in_group=3

innodb_checksums=0
innodb_checksum_algorithm=none
#innodb_support_xa=0
#innodb_thread_concurrency=0
innodb_max_dirty_pages_pct=90
tmpdir=/fioa/tmp
innodb_data_file_path=ibdata1:76M;../../var/log/mysql/ibdata2:500M:autoextend
innodb_log_group_home_dir=/var/log/mysql
innodb_log_buffer_size=64M
#innodb_force_recovery=6
#innodb_flush_neighbors=0
innodb_read_ahead_threshold=0
innodb_lru_scan_depth=2000
##innodb_page_size = ‘16K’
innodb_log_block_size=4096
innodb_buffer_pool_instances=16
innodb_buffer_pool_populate=1

#large-pages
#query_cache_size=0

[client]
socket=/fioa/mysql/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
malloc-lib=/usr/lib64/libjemalloc.so.1
flush_caches=1
numa_interleave=1