From 513e5442723f501525bf9ca6210b16561e5d3a2b Mon Sep 17 00:00:00 2001
From: zyy <zyy@email.com>
Date: Tue, 24 Mar 2026 11:41:07 +0800
Subject: [PATCH] 1
---
trading-order-admin/src/main/resources/application-prod.yml | 27 +++++++++++++++------------
1 files changed, 15 insertions(+), 12 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..d238d16 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: 8235
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/Tokyo&useLegacyDatetimeCode=false
+ 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=Asia/Tokyo&useLegacyDatetimeCode=false
+ username: trading_order
+ password: dhG2xEAnkx3Xs6mt
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/Tokyo
jackson:
- time-zone: Europe/Paris
+ time-zone: Asia/Tokyo
cache:
type: redis
redis:
@@ -49,4 +52,4 @@
maxIdle: 20
maxTotal: 50
host: 127.0.0.1
- port: 6380
+ port: 6379
--
Gitblit v1.9.3