From 642ee1e7d27a1fef6c5008a235bb80b1b3ce7818 Mon Sep 17 00:00:00 2001
From: Britney Fransen <brfransen@gmail.com>
Date: Mon, 3 Feb 2025 13:00:29 -0500
Subject: linhes-system: lh_sqlserver.cnf: update defaults

---
 linhes/linhes-system/PKGBUILD         |  4 ++--
 linhes/linhes-system/lh_sqlserver.cnf | 15 ++++++++-------
 2 files changed, 10 insertions(+), 9 deletions(-)

diff --git a/linhes/linhes-system/PKGBUILD b/linhes/linhes-system/PKGBUILD
index b86b1f8..47cb98a 100755
--- a/linhes/linhes-system/PKGBUILD
+++ b/linhes/linhes-system/PKGBUILD
@@ -1,6 +1,6 @@
 pkgname=linhes-system
 pkgver=9.0.0
-pkgrel=89
+pkgrel=90
 arch=('x86_64')
 #install=$pkgname.install
 pkgdesc="Everything that makes LinHES a system"
@@ -81,7 +81,7 @@ sha256sums=('e6eaa2fb4819fa60cb05b4d2e7328d2914af3a73028a735ec4d56e7ece33ecc0'
             'dae799f09a076e0f573ea516bc357f56f2fd3aa8e35ec0cf54b6b62282960ee0'
             'aa1d831f25317a9cb8d7e9a7d7b6d51c8d03bd5b69f3bec27bea7644ca38fe9a'
             'cf884bad5caab9d5901b88b0ef41e3a39ea0b7a4614b8d14707d79941c899cbf'
-            '3ed91fb5a7894f82fb4895e06d2e3f1df3ac4f82e46c970d4a85aaa4edc24cf1'
+            '01416dadeb34ca8b18bb7326113672b3888b16a60133d501d48610d23b74d1eb'
             '197ff4bb3c1cafcb197268cac335f1f75ae26873aca5833d62cc51fade85176c'
             '0b9868a563036c81f8fdb8ab8bbad51934aca2a07e9d7634e24214791afda8e2'
             '1b965b5e7eeafdf3815c8f2722587a560693dd780327cca9910dc47fba0f1aef'
diff --git a/linhes/linhes-system/lh_sqlserver.cnf b/linhes/linhes-system/lh_sqlserver.cnf
index be2d5bd..6475ea2 100644
--- a/linhes/linhes-system/lh_sqlserver.cnf
+++ b/linhes/linhes-system/lh_sqlserver.cnf
@@ -41,9 +41,10 @@
 datadir=/data/srv/mysql
 
 skip-external-locking
+skip-name-resolve=ON
 
 net_buffer_length = 8K
-key_buffer_size = 768M
+key_buffer_size = 512M
 max_allowed_packet = 1M
 tmp_table_size = 256M
 max_heap_table_size = 256M
@@ -55,9 +56,10 @@ thread_cache_size = 8
 query_cache_type = 0
 query_cache_size = 0
 query_cache_limit = 2M
-join_buffer_size = 1M
-ignore-db-dir = lost+found
+join_buffer_size = 2M
+ignore_db_dirs = lost+found
 table_open_cache = 5000
+table_definition_cache = 800
 open_files_limit = 10000
 
 # Uncomment the following if you are using InnoDB tables
@@ -66,14 +68,13 @@ open_files_limit = 10000
 #innodb_log_group_home_dir = /var/lib/mysql
 # You can set .._buffer_pool_size up to 50 - 80 %
 # of RAM but beware of setting memory usage too high
-#innodb_buffer_pool_size = 16M
+innodb_buffer_pool_size = 1500M
 #innodb_additional_mem_pool_size = 2M
 # Set .._log_file_size to 25 % of buffer pool size
-innodb_log_file_size = 16M
-#innodb_log_buffer_size = 8M
+innodb_log_file_size = 375M
+innodb_log_buffer_size = 32M
 #innodb_flush_log_at_trx_commit = 1
 #innodb_lock_wait_timeout = 50
-innodb_buffer_pool_instances = 1
 
 # This group is only read by MariaDB-10.8 servers.
 # If you use the same .cnf file for MariaDB of different versions,
-- 
cgit v0.12

