freenas-iocage-nextcloud icon indicating copy to clipboard operation
freenas-iocage-nextcloud copied to clipboard
verified publisher icon danb35

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

Open rm76 opened this issue 2 years ago • 2 comments

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?

rm76 avatar Aug 28 '23 12:08 rm76

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?

DD8372812 avatar Nov 13 '23 10:11 DD8372812

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

slothish avatar Apr 02 '24 11:04 slothish