优化

huliguo

2025-05-29 bddd4e90123c580863f713798117504632a54c8e

 guns-admin/src/main/resources/application.yml

@@ -12,10 +12,9 @@
spring:
  redis:
    database: 0
    host: 10.25.14.40
    host: localhost
    port: 6379
    password: 34b7b13ce8a711e4:chengshI2014

    password: 123456

---

@@ -42,6 +41,11 @@
  typeAliasesPackage: com.stylefeng.guns.modular
  configuration:
    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
# 日志配置
logging:
  level:
    com.stylefeng: debug
    org.springframework: warn


---
@@ -56,57 +60,58 @@
#线上环境
spring:
  datasource:
    url: jdbc:mysql://rm-m5e57gbu0gdv901ub.mysql.rds.aliyuncs.com:3306/vehicle_inspection?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Asia/Shanghai
    username: vehicleInspection
    password: SYzt1953123456
    url: jdbc:mysql://192.168.110.85:3306/vehicle_inspection?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
    db-name: guns #用来搜集数据库的所有表
    filters: wall,mergeStat
#    filters: wall,mergeStat


#多数据源情况的配置
guns:
  muti-datasource:
    open: false
    url: jdbc:mysql://127.0.0.1:3306/guns_test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root
    dataSourceNames:
      - dataSourceGuns
      - dataSourceBiz
#guns:
#  muti-datasource:
#    open: false
#    url: jdbc:mysql://127.0.0.1:3306/guns_test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Asia/Shanghai
#    username: root
#    password: root
#    dataSourceNames:
#      - dataSourceGuns
#      - dataSourceBiz

---
spring:
  quartz:
    job-store-type: jdbc
    jdbc:
      initialize-schema: embedded
    properties:
      org:
        quartz:
          scheduler:
            # 调度器实例名称
            instanceName: QuartzScheduler
            # 分布式节点ID自动生成
            instanceId: AUTO
          jobStore:
            class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
            driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
            # 表前缀
            tablePrefix: qrtz_
            # 是否开启集群
            isClustered: false
            # 数据源别名（自定义）
            dataSource: vehicle_inspection
            # 分布式节点有效性检查时间间隔（毫秒）
            clusterCheckinInterval: 10000
            useProperties: false
          # 线程池配置
          threadPool:
            class: org.quartz.simpl.SimpleThreadPool
            threadCount: 10
            threadPriority: 5
            threadsInheritContextClassLoaderOfInitializingThread: true
            
#spring:
#  quartz:
#    job-store-type: jdbc
#    jdbc:
#      initialize-schema: embedded
#    properties:
#      org:
#        quartz:
#          scheduler:
#            # 调度器实例名称
#            instanceName: QuartzScheduler
#            # 分布式节点ID自动生成
#            instanceId: AUTO
#          jobStore:
#            class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
#            driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
#            # 表前缀
#            tablePrefix: qrtz_
#            # 是否开启集群
#            isClustered: false
#            # 数据源别名（自定义）
#            dataSource: vehicle_inspection
#            # 分布式节点有效性检查时间间隔（毫秒）
#            clusterCheckinInterval: 10000
#            useProperties: false
#          # 线程池配置
#          threadPool:
#            class: org.quartz.simpl.SimpleThreadPool
#            threadCount: 10
#            threadPriority: 5
#            threadsInheritContextClassLoaderOfInitializingThread: true
#
---
# 任务执行最大线程数
maxThreadCount: 50