[mysqld]
############# INNODB #############
innodb_buffer_pool_size = 4G //innodb缓存池大小设置
innodb_io_capacity = 4000 //innodb每秒的io次数设置
innodb_max_dirty_pages_pct = 75 //innodb缓存池中脏页的最大比例
innodb_strict_mode = ON
innodb_file_per_table = ON //每个表开启独立的表空间
innodb_flush_method = O_DIRECT //将缓存中的数据刷新到磁盘的策略:direct io
innodb_checksum_algorithm = strict_crc32
innodb_thread_concurrency = 0
innodb_print_all_deadlocks = 1
innodb_numa_interleave = ON
#innodb_data_file_path = ibdata1:128M:autoextend
#innodb_temp_data_file_path = ibtmp1:128M:autoextend:max:10G
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
innodb_page_size = 16K //innodb缓存池中单位页的大小设置
innodb_online_alter_log_max_size = 4G
innodb_flush_neighbors = 0
innodb_log_buffer_size = 32M //innodb事务日志的缓存大小设置
#innodb_log_file_size = 512M
#innodb_log_files_in_group = 3
innodb_flush_log_at_trx_commit = 1 //innodb事务日志的刷新策略
#innodb_max_undo_log_size = 2G
#innodb_undo_tablespaces = 3
innodb_write_io_threads = 8 //innodb并发write io线程设置
innodb_read_io_threads = 8 //innodb并发read io线程设置
innodb_purge_threads = 4
innodb_page_cleaners = 4 //innodb刷新脏页到磁盘的线程设置