I thought I am being very clever and created multiple datasets for my storagenode:
STORJ/storage with recordsize=16K for the database files
STORJ/storage/blobs with recordsize=1M for all pieces
STORJ/storage/trash and the other directories with recordsize=1M
First: This was a bad idea because you can’t move files between datasets and therefore many uploads fail and it doesn’t work correctly… Stupid mistake…
Second: Now I have everything in a dataset with recordsize=1M which is great for pieces but the sqlite database will probably hate it… I can’t find much information about using a sqlite database with high recordsize settings. Any insights on this?
I am using an arc/l2arc and zil so the db should be cached most of the time anyway but I still wonder about the effect of storing that db on a dataset with such a big recordsize.
Third: This has been asked many times and sadly always denied… Please make it possible to move the databases into a separate mountpoint! It’s not that difficult to just give all database files their own directory…