search

danb35 / freenas-iocage-nextcloud

Script to create an iocage jail on FreeNAS for the latest Nextcloud 28 release, including Caddy, MariaDB or PostgreSQL, and Let's Encrypt
GNU General Public License v3.0
250 stars 71 forks source link

record size for database dataset: 16K or 32K? #207

Open rm76 opened 10 months ago

rm76 commented 10 months ago

When setting up a dataset for the database and setting 16K as record size, I get this warning: WARNING: Based on the pool topology, 32K is the minimum recommended record size. Choosing a smaller size can reduce system performance. Should I go for 16K or 32K?

DD8372812 commented 7 months ago

I recently reinstalled Nextcloud using this script and asked myself the same question. I have selected 16K.

After the successful installation Nextcloud Web GUI is very sluggish. Could this have something to do with the wrong size?

slothish commented 3 months ago

You want a record size of 16k

https://kitcharoenp.github.io/mysql/zfs/mariadb/2021/10/18/zfs-tunning-optimization.html

To get the best performance you should put the database on a dedicated ssd pool