Nextcloud Useful Tricks
MariaDB or PostgreSQL?
Personally, I never liked PostgreSQL. Don’t ask me why. So, when I build my last server, I give MariaDB a shot. Man, it was hard. Too much CPU, too much memory usage, interface as slow as can be. Read a lot, learned a lot. Something about indexing tables, which I have no idea where to start. Man, I read people using Raspberry Pi with this thing and getting some kind of satisfactory performance. How come my dual Xeon X5460 with 64GB of RAM and 16TB wasn’t flying? Tried everything. MyISAM, innodb, add memory, taking memory off. Nothing worked. I quit. Made a conversion to Postgresql. Waited the index of the files, took about 3 days. Then I read something about VTd-E, decided to give another try to MariaDB. Worked. But not because of VTd-E, especially because my CPU doesn’t have support for this. It was the oc_filecache all reindexed. I don’t know if it was because of a occ db index patch I made right after I went back to MariaDB or just because all files were already indexed by postgresql and all that trouble of catalog files wasn’t necessary anymore. Or even worse, because I changed a driver of my SAS to a serial driver, instead of the paravirtual vmware property driver. Lessons I learned: Never delete oc_filecache. Took too long to go back on track after. A fresh install would be faster.