Optimize mysql and postgresql for write IO

[perso/Immae/Config/Nix.git] / modules / private / databases / mariadb.nix

diff --git a/modules/private/databases/mariadb.nix b/modules/private/databases/mariadb.nix
index 632306cf23193c3caf96aec68a5cdaae637afc7c..3359064b9d3f6141be744f183c02225177c3dbe0 100644 (file)
--- a/modules/private/databases/mariadb.nix
+++ b/modules/private/databases/mariadb.nix
@@ -102,6 +102,10 @@ in {
         # for replication
         log-bin=mariadb-bin
         server-id=1
+
+        # this introduces a small delay before storing on disk, but
+        # makes it order of magnitudes quicker
+        innodb_flush_log_at_trx_commit = 0
         '';
     };