From 07ffe1dc04495e2584fb714ca52bf8801053d1d9 Mon Sep 17 00:00:00 2001
From: zyy <zyy@email.com>
Date: Thu, 23 Oct 2025 17:11:06 +0800
Subject: [PATCH] 修改资金密码

---
 trading-order-admin/src/main/resources/application-prod.yml |   25 ++++++++++++++-----------
 1 files changed, 14 insertions(+), 11 deletions(-)

diff --git a/trading-order-admin/src/main/resources/application-prod.yml b/trading-order-admin/src/main/resources/application-prod.yml
index c33a4a1..81e36ea 100644
--- a/trading-order-admin/src/main/resources/application-prod.yml
+++ b/trading-order-admin/src/main/resources/application-prod.yml
@@ -1,26 +1,29 @@
 server:
-  port: 8225
+  port: 8806
 spring:
   datasource:
-#    url: jdbc:mysql://127.0.0.1:6306/8.4?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Europe/Paris&useLegacyDatetimeCode=false
-    url: jdbc:mysql://127.0.0.1:6306/trading_order_sy?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Europe/Paris&useLegacyDatetimeCode=false
-    username: trading_order_sy
-    password: S4yrh3b3hypfbfed
+#    url: jdbc:mysql://127.0.0.1:6306/8.4?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Asia/Shanghai&useLegacyDatetimeCode=false
+    url: jdbc:mysql://127.0.0.1:6306/trad_order_1015?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&serverTimezone=Asia/Shanghai&useLegacyDatetimeCode=false
+    username: trad_order_1015
+    password: fin6GDm2MhsFyRmm
     driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.zaxxer.hikari.HikariDataSource
     hikari:
-      minimum-idle: 0
-      maximum-pool-size: 20
-      idle-timeout: 25000
+      minimum-idle: 10  # 最小空闲连接数,建议与max-pool-size差距不要太大(避免频繁创建/销毁连接)
+      maximum-pool-size: 100  # 提高最大连接数(根据数据库能承受的并发连接数调整,需与DBA确认)
+      idle-timeout: 60000  # 空闲连接超时时间(1分钟),超过后释放
       auto-commit: true
-      connection-test-query: SELECT 1
+      max-lifetime: 1800000  # 连接最大存活时间(30分钟),避免长期占用导致的僵死连接
+      connection-timeout: 30000  # 延长连接获取超时时间(30秒,避免因短暂峰值误报)
+      connection-test-query: SELECT 1  # 连接校验SQL(检测连接是否有效,MySQL示例,其他数据库需调整)
+      validation-timeout: 5000  # 连接校验超时时间(5秒)
   jpa:
     properties:
       hibernate:
         jdbc:
-          time_zone: Europe/Paris
+          time_zone: Asia/Shanghai
   jackson:
-    time-zone: Europe/Paris
+    time-zone: Asia/Shanghai
     cache:
       type: redis
       redis:

--
Gitblit v1.9.3