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 | |
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')
-rw-r--r-- | modules/private/databases/mariadb.nix | 4 | ||||
-rw-r--r-- | modules/private/databases/postgresql.nix | 3 |
2 files changed, 7 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 | ||
diff --git a/modules/private/databases/postgresql.nix b/modules/private/databases/postgresql.nix index 1932a82..3dcd311 100644 --- a/modules/private/databases/postgresql.nix +++ b/modules/private/databases/postgresql.nix | |||
@@ -161,6 +161,9 @@ in { | |||
161 | lc_numeric = 'en_US.UTF-8' | 161 | lc_numeric = 'en_US.UTF-8' |
162 | lc_time = 'en_US.UTF-8' | 162 | lc_time = 'en_US.UTF-8' |
163 | default_text_search_config = 'pg_catalog.english' | 163 | default_text_search_config = 'pg_catalog.english' |
164 | # this introduces a small delay before storing on disk, but | ||
165 | # makes it order of magnitudes quicker | ||
166 | synchronous_commit = off | ||
164 | ssl = on | 167 | ssl = on |
165 | ssl_cert_file = '${config.security.acme.directory}/postgresql/fullchain.pem' | 168 | ssl_cert_file = '${config.security.acme.directory}/postgresql/fullchain.pem' |
166 | ssl_key_file = '${config.security.acme.directory}/postgresql/key.pem' | 169 | ssl_key_file = '${config.security.acme.directory}/postgresql/key.pem' |