Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/nextcloud/nextcloudpi.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authornachoparker <nacho@ownyourbits.com>2019-02-22 23:45:15 +0300
committernachoparker <nacho@ownyourbits.com>2019-03-05 21:22:12 +0300
commite39c3abd5b4c6268796bf6d7cc91c22c8a783d86 (patch)
treee606310d9169127151ace1da4594342395c1601e /update.sh
parent160e295c684d37957bf352d384ea07b6360bc053 (diff)
lamp: adjust mariadb parametersv1.8.2
Diffstat (limited to 'update.sh')
-rwxr-xr-xupdate.sh32
1 files changed, 32 insertions, 0 deletions
diff --git a/update.sh b/update.sh
index 90546278..90ae4745 100755
--- a/update.sh
+++ b/update.sh
@@ -309,6 +309,38 @@ EOF
bash -c "sleep 2 && service apache2 reload" &>/dev/null &
fi
+ # configure MariaDB (UTF8 4 byte support)
+ [[ -f /etc/mysql/mariadb.conf.d/91-ncp.cnf ]] || {
+ cat > /etc/mysql/mariadb.conf.d/91-ncp.cnf <<EOF
+[mysqld]
+transaction_isolation = READ-COMMITTED
+innodb_large_prefix=true
+innodb_file_per_table=1
+innodb_file_format=barracuda
+
+[server]
+# innodb settings
+skip-name-resolve
+innodb_buffer_pool_size = 256M
+innodb_buffer_pool_instances = 1
+innodb_flush_log_at_trx_commit = 2
+innodb_log_buffer_size = 32M
+innodb_max_dirty_pages_pct = 90
+innodb_log_file_size = 32M
+
+# disable query cache
+query_cache_type = 0
+query_cache_size = 0
+
+# other
+tmp_table_size= 64M
+max_heap_table_size= 64M
+EOF
+ ncc maintenance:mode --on
+ service mysql restart
+ ncc maintenance:mode --off
+ }
+
# remove redundant opcache configuration. Leave until update bug is fixed -> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=815968
# Bug #416 reappeared after we moved to php7.2 and debian buster packages. (keep last)
[[ "$( ls -l /etc/php/7.2/fpm/conf.d/*-opcache.ini | wc -l )" -gt 1 ]] && rm "$( ls /etc/php/7.2/fpm/conf.d/*-opcache.ini | tail -1 )"