diff options
author | Ismaël Bouya <ismael.bouya@normalesup.org> | 2019-12-20 01:51:17 +0100 |
---|---|---|
committer | Ismaël Bouya <ismael.bouya@normalesup.org> | 2019-12-20 04:12:30 +0100 |
commit | 0907cf1ba08ad04cff9b1fe805ac6f2072c24142 (patch) | |
tree | 9be77c9bb710497372c4749822348916b166d63b /modules/private/databases/mariadb.nix | |
parent | ab8f306d7c2c49b8116e1af7b355ed2384617ed9 (diff) | |
download | Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.tar.gz Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.tar.zst Nix-0907cf1ba08ad04cff9b1fe805ac6f2072c24142.zip |
Optimize mysql and postgresql for write IO
Diffstat (limited to 'modules/private/databases/mariadb.nix')
-rw-r--r-- | modules/private/databases/mariadb.nix | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/modules/private/databases/mariadb.nix b/modules/private/databases/mariadb.nix index 632306c..3359064 100644 --- a/modules/private/databases/mariadb.nix +++ b/modules/private/databases/mariadb.nix | |||
@@ -102,6 +102,10 @@ in { | |||
102 | # for replication | 102 | # for replication |
103 | log-bin=mariadb-bin | 103 | log-bin=mariadb-bin |
104 | server-id=1 | 104 | server-id=1 |
105 | |||
106 | # this introduces a small delay before storing on disk, but | ||
107 | # makes it order of magnitudes quicker | ||
108 | innodb_flush_log_at_trx_commit = 0 | ||
105 | ''; | 109 | ''; |
106 | }; | 110 | }; |
107 | 111 | ||