[mysqld]
innodb_autoinc_lock_mode                = 2
innodb_buffer_pool_size                 = 2G
innodb_file_per_table                   = ON
innodb_flush_log_at_trx_commit          = 2
innodb_flush_method                     = O_DIRECT
innodb_log_file_size                    = 1G
innodb_log_buffer_size                  = 32MB
innodb_thread_concurrency               = 0
innodb_use_native_aio                   = OFF