From 45d90d1e7ba86286e998d1ac4d2cba8e98cd059b Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期一, 12 一月 2026 20:52:30 +0800
Subject: [PATCH] feat: 优化内存

---
 ruoyi-admin/src/main/resources/application-dev.yml |   14 ++++++++++++--
 1 files changed, 12 insertions(+), 2 deletions(-)

diff --git a/ruoyi-admin/src/main/resources/application-dev.yml b/ruoyi-admin/src/main/resources/application-dev.yml
index 0277f9e..13f31b7 100644
--- a/ruoyi-admin/src/main/resources/application-dev.yml
+++ b/ruoyi-admin/src/main/resources/application-dev.yml
@@ -27,7 +27,7 @@
             # 鍒濆杩炴帴鏁�
             initialSize: 5
             # 鏈�灏忚繛鎺ユ睜鏁伴噺
-            minIdle: 10
+            minIdle: 5
             # 鏈�澶ц繛鎺ユ睜鏁伴噺
             maxActive: 20
             # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂�
@@ -41,12 +41,22 @@
             # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
             minEvictableIdleTimeMillis: 300000
             # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
-            maxEvictableIdleTimeMillis: 900000
+            maxEvictableIdleTimeMillis: 600000
             # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁�
             validationQuery: SELECT 1
             testWhileIdle: true
             testOnBorrow: false
             testOnReturn: false
+            # 鏄惁缂撳瓨preparedStatement锛屼篃灏辨槸PSCache锛堟彁鍗囨�ц兘浣嗗鍔犲唴瀛橈紝Oracle寤鸿寮�鍚紝MySQL寤鸿鍏抽棴锛�
+            poolPreparedStatements: false
+            # 姣忎釜杩炴帴鐨凱SCache澶у皬锛圡ySQL寤鸿鍏抽棴PSCache锛岃涓�-1锛�
+            maxPoolPreparedStatementPerConnectionSize: -1
+            # 閰嶇疆绉婚櫎搴熷純杩炴帴锛堥暱鏃堕棿鏈綊杩樼殑杩炴帴锛�
+            removeAbandoned: true
+            # 杩炴帴琚崰鐢ㄨ秴杩囨鏃堕棿锛堢锛夎涓哄簾寮�
+            removeAbandonedTimeout: 1800
+            # 鏄惁璁板綍搴熷純杩炴帴鐨勫爢鏍堜俊鎭�
+            logAbandoned: true
             webStatFilter: 
                 enabled: true
             statViewServlet:

--
Gitblit v1.9.1