From e39c3abd5b4c6268796bf6d7cc91c22c8a783d86 Mon Sep 17 00:00:00 2001
From: nachoparker <nacho@ownyourbits.com>
Date: Fri, 22 Feb 2019 13:45:15 -0700
Subject: lamp: adjust mariadb parameters

---
 update.sh | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'update.sh')

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 )"
-- 
cgit v1.2.3