From c7c4c4eec809cfd5e399edab50fae9bf68681585 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Tue, 03 Feb 2026 18:32:44 +0800
Subject: [PATCH] 1
---
trading-order-admin/src/main/resources/application-prod.yml | 21 ++++++++++++---------
1 files changed, 12 insertions(+), 9 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..1dd7916 100644
--- a/trading-order-admin/src/main/resources/application-prod.yml
+++ b/trading-order-admin/src/main/resources/application-prod.yml
@@ -1,19 +1,22 @@
server:
- port: 8225
+ port: 9225
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:3306/trading_order?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
+ password: 43it2nK3JeSkH8de
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:
@@ -49,4 +52,4 @@
maxIdle: 20
maxTotal: 50
host: 127.0.0.1
- port: 6380
+ port: 6379
--
Gitblit v1.9.3