Thank you for this. I really dislike MySQL/MariaDB and favor SQLite whenever possible, or PostgreSQL otherwise. The DB migration of my Nextcloud instance was high in my to-do list, and your instructions saved me research time.
Thank you for this. I really dislike MySQL/MariaDB and favor SQLite whenever possible, or PostgreSQL otherwise. The DB migration of my Nextcloud instance was high in my to-do list, and your instructions saved me research time.
tofubl@discuss.tchncs.de 1 year ago
Here’s a cool article I found on Nextcloud performance improvements, and connecting Redis over Unix sockets gave me a more substantial performance improvement than migrating to Postgres. Very happy I fell down this rabbit hole today.
To note if you’re following the tutorial in the link above, and for people using the nextcloud:stable container together with the recommended cron container:
config/config.php
, as well asconfig/redis.config.php
/etc/localtime
and/etc/timezone
volumes the app container did, as well as thevolumes_from: tmp
haplo@lemmy.world 1 year ago
Thank you for the link and the Redis pointers. I should double check that my Nextcloud setup is using Redis, it might well be misconfigured.
sj_zero 1 year ago
If you do end up using postgresql, over time the database could end up getting fragmented and that can lead to increased latency, so routine pg_repacks imo are a worthwhile thing to schedule.