From 09fa0b6d38a97f3e89cb30aa2d4b0030bbcb5b6a Mon Sep 17 00:00:00 2001
From: zyy <zyy@email.com>
Date: Tue, 16 Dec 2025 16:57:34 +0800
Subject: [PATCH] 演示yml

---
 trading-order-admin/src/main/resources/application-prod.yml |   51 +++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 43 insertions(+), 8 deletions(-)

diff --git a/trading-order-admin/src/main/resources/application-prod.yml b/trading-order-admin/src/main/resources/application-prod.yml
index 9db047b..dd06ad8 100644
--- a/trading-order-admin/src/main/resources/application-prod.yml
+++ b/trading-order-admin/src/main/resources/application-prod.yml
@@ -1,20 +1,55 @@
 server:
-  port: 8111
+  port: 9225
 spring:
   datasource:
-    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
-    username: root
-    password: 123456
+#    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:3306/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: 78FLt5fLZLhcXHhz
     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
+  jackson:
+    time-zone: Europe/Paris
+    cache:
+      type: redis
+      redis:
+        cache-null-values: true
   redis:
     redisson:
       config: classpath:redisson/redisson-dev.yml
 logging:
   config: classpath:logback/logback-prod.xml
+
+jetcache:
+  statIntervalMinutes: 1
+  default: # 默认default,可以配置更多的area
+    type: linkedhashmap # 已支持可选:linkedhashmap、caffeine
+    keyConvertor: fastjson # key转换器
+  remote:
+    default:
+      # 缓存类型。tair、redis为当前支持的远程缓存
+      type: redis
+      keyConvertor: fastjson
+      # 采用Java序列化存储
+      valueEncoder: java
+      valueDecoder: java
+      poolConfig:
+        minIdle: 5
+        maxIdle: 20
+        maxTotal: 50
+      host: 127.0.0.1
+      port: 6379

--
Gitblit v1.9.3