From 5e765b7358c0a1f91b30acf48d442c08073fdbed Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 30 九月 2025 16:06:58 +0800
Subject: [PATCH] 优化数据源配置
---
pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml | 19 +++++++++++++------
1 files changed, 13 insertions(+), 6 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
index 700142f..7ebcfe7 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
@@ -5,8 +5,9 @@
#name: ym
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
- url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
-# url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+# url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+# url: jdbc:mysql://8.130.130.233:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+ url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
username: root
password: dysql,;.abc!@#
druid:
@@ -15,7 +16,7 @@
#閰嶇疆鍒濆鍖栧ぇ灏忋�佹渶灏忋�佹渶澶�
initialSize: 10
minIdle: 10
- maxActive: 200
+ maxActive: 100
# 鑾峰彇杩炴帴鏃舵渶澶х瓑寰呮椂闂�,鍗曚綅姣銆傞厤缃簡maxWait涔嬪悗,缂虹渷鍚敤鍏钩閿�,骞跺彂鏁堢巼浼氭湁鎵�涓嬮檷,濡傛灉闇�瑕佸彲浠ラ�氳繃閰嶇疆useUnfairLock灞炴�т负true浣跨敤闈炲叕骞抽攣
maxWait: 60000
#閰嶇疆闂撮殧澶氫箙杩涜涓�娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆绉掋�� 榛樿鏄�60s锛屽お闀垮彲鑳戒細瀵艰嚧鏃犳硶鍙婃椂妫�娴嬪埌杩炴帴涓柇
@@ -44,8 +45,13 @@
#鎸囧畾姣忎釜杩炴帴涓奝SCache鐨勫ぇ灏�
maxPoolPreparedStatementPerConnectionSize: 20
#灞炴�х被鍨嬫槸瀛楃涓诧紝閫氳繃鍒悕鐨勬柟寮忛厤缃墿灞曟彃浠讹紝甯哥敤鐨勬彃浠舵湁锛�
- #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屾棩蹇楃敤鐨刦ilter:log4j锛岄槻寰ql娉ㄥ叆鐨刦ilter:wall
- filters: stat,wall,config
+ #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屽惎鐢ㄦ閰嶇疆锛孞dbcDataSourceStat闈欐�佸彉閲廘inkedHashMap<String, JdbcSqlStat> sqlStatMap鐨凪ap浼氫竴鐩磋鎸佹湁鎵�鏈塖QL涓嶈兘琚獹C閲婃斁锛屽鏄撳唴瀛樻硠闇�
+ #鏃ュ織鐢ㄧ殑filter:log4j锛�
+ #闃插尽sql娉ㄥ叆鐨刦ilter:wall
+ #filters: stat,wall,config
+ filters: wall,config
+ #褰� Druid 鏁版嵁婧愶紙DataSource锛夎繖涓� Bean 琚� Spring 瀹瑰櫒閿�姣佹椂锛岄渶瑕佽皟鐢ㄧ殑鏂规硶
+ destroy-method: close
webStatFilter:
# 娣诲姞杩囨护瑙勫垯
urlPattern: /*
@@ -62,5 +68,6 @@
# 鏄惁鍙互閲嶇疆鏁版嵁
resetEnable: false
# 寮�鍚痙ruid鐩戞帶椤甸潰
- enabled: true
+ #enabled: true
+ enabled: false
--
Gitblit v1.8.0