innodb性能优化配置关键项

innodb_buffer_pool_size=8G
innodb_log_file_size=256M
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT