Changing innodb_flush_log_at_trx_commit in MySQL/MariaDB innodb performance

 Default value is 1, possible values are 0-2.

0 – Logs are written and flushed to disk once per second. Transactions that have not been flushed out can be lost as a result of a crash.

1 – Logs are written and flushed to disk every time a transaction is committed.

2 – Logs are written after each commit of a transaction and flushed to disk once per second. Transactions that have not been flushed out can be lost in the event of a failure.