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
258 stars 71 forks source link

Set recommended transaction isolation for mariadb #54

Closed Sohalt closed 5 years ago

Sohalt commented 5 years ago

See https://github.com/nextcloud/documentation/blob/master/admin_manual/configuration_database/linux_database_configuration.rst#database-read-committed-transaction-isolation-level

danb35 commented 5 years ago

The configs/my.cnf file is the root user's .my.cnf; this needs to go in the system .my.cnf. I can't get to it at the moment, but I believe it's going to be in /usr/local/etc/mysql/.

Sohalt commented 5 years ago

Sorry, thanks for catching that. It should be in the correct file now. Not sure if the patching with sed is the nicest way to do it though.