MySQL 2 parameters for transaction and security

Innodb_flush_log_at_trx_commit: (The way MySQL writes things log) 0log buffer writes to the log file per second and flushes to disk (submission is not a matter of things, performance is best) 1 things are written to the log file, and swipe into the disk (most secure, slowest) 2 things are logged to the log file, and the log files are flushed to disk every 1 seconds----------------------------------------------------------------- Sync_binlog: (the way MySQL writes binary logs) 0binlog does not actively sync to disk, but relies on the operating system to brush files to disk on an irregular basis. 1 each thing synchronizes once binlog to disk.

MySQL 2 parameters for transaction and security