默認(rèn)的配置無法自定義hikari的配置數(shù)據(jù)兑徘，只能使用默認(rèn)值

示例中開啟了MicrometerMetricsTrackerFactory

添加mysql jdbc依賴

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

自定義Hikari配置類

@ConfigurationProperties("spring.datasource.hikari")
public class HikariProperties extends HikariConfig {
    /**
     * metrics日志輸出時間間隔同廉，單位分鐘
     */
    @Value("${loggingMeterPushMetricsStep:15}")
    private int loggingMeterPushMetricsStep;

    public int getLoggingMeterPushMetricsStep() {
        return loggingMeterPushMetricsStep;
    }

    public void setLoggingMeterPushMetricsStep(int loggingMeterPushMetricsStep) {
        this.loggingMeterPushMetricsStep = loggingMeterPushMetricsStep;
    }
}

配置類

@Configuration
@EnableConfigurationProperties({HikariProperties.class})
public class HikariConfiguration {
    private final Logger log = LoggerFactory.getLogger(HikariConfiguration.class);
    private final DataSourceProperties dataSourceProperties;
    private final HikariProperties hikariProperties;

    public HikariConfiguration(DataSourceProperties dataSourceProperties, HikariProperties hikariProperties) {
        this.dataSourceProperties = dataSourceProperties;
        this.hikariProperties = hikariProperties;
    }

    @Bean
    public DataSource dataSource() {
        log.info("初始化數(shù)據(jù)源埋心，使用Hikari數(shù)據(jù)庫連接池");
        hikariProperties.setJdbcUrl(dataSourceProperties.getUrl());
        hikariProperties.setUsername(dataSourceProperties.getUsername());
        hikariProperties.setPassword(dataSourceProperties.getPassword());
        hikariProperties.setDriverClassName(dataSourceProperties.getDriverClassName());
        hikariProperties.setMetricsTrackerFactory(initMicrometerMetricsTrackerFactory());
        HikariDataSource dataSource = new HikariDataSource(hikariProperties);
        return dataSource;
    }

    private MicrometerMetricsTrackerFactory initMicrometerMetricsTrackerFactory() {
        log.info("使用LoggingMeterRegistry構(gòu)建Hikari數(shù)據(jù)連接池的MicrometerMetricsTrackerFactory");
        final LoggingMeterRegistry registry = LoggingMeterRegistry
                .builder(new LoggingRegistryConfig() {

                    @Override
                    public String get(String key) {
                        return null;
                    }

                    @Override
                    public Duration step() {
                        return getDuration(this, "step").orElse(Duration.ofMinutes(hikariProperties.getLoggingMeterPushMetricsStep()));
                    }
                })
                .threadFactory(new NamedThreadFactory("hikari-logging-metrics-publisher"))
                .build();
        return new MicrometerMetricsTrackerFactory(registry);
    }
}

yaml配置

spring:
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    url: jdbc:mysql://192.168.110.108:3306/aus-call-center?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=GMT%2B8
    username: root
    password: shanglian123
    driver-class-name: com.mysql.cj.jdbc.Driver
    # 參照https://github.com/brettwooldridge/HikariCP#gear-configuration-knobs-baby
    hikari:
      # 默認(rèn)值30000 
      connectionTimeout: 10000
      # 默認(rèn)值5000
      validationTimeout: 1000
      # 空閑時間 默認(rèn)值10000
      idleTimeout: 10000
      maxLifetime: 30000
      # 默認(rèn)值10
      maximumPoolSize: 5
      minimumIdle: 3
      poolName: "mysql-auscallcenter-pool"
      loggingMeterPushMetricsStep: 15
      # mysql性能調(diào)優(yōu)參數(shù)指郁，參照https://github.com/brettwooldridge/HikariCP/wiki/MySQL-Configuration
      data-source-properties:
        cachePrepStmts: true
        prepStmtCacheSize: 250
        prepStmtCacheSqlLimit: 2048
        useServerPrepStmts: true
        useLocalSessionState: true
        # 批量增刪改數(shù)據(jù)時效率高
        rewriteBatchedStatements: true
        cacheResultSetMetadata: true
        cacheServerConfiguration: true
        elideSetAutoCommits: true
        maintainTimeStats: false