[Java] Spring Boot如何使用HikariCP连接池详解

pluginmanagement {
  repositories {
    gradlepluginportal()
  }
}
rootproject.name = 'datasource-config'
 
plugins {
  id 'org.springframework.boot' version '2.1.3.release'
  id 'java'
}
 
apply plugin: 'io.spring.dependency-management'
 
group = 'spring-boot-guides'
version = '0.0.1-snapshot'
sourcecompatibility = '1.8'
 
repositories {
  mavencentral()
}
 
dependencies {
  implementation 'org.springframework.boot:spring-boot-starter-jdbc'
  runtimeonly 'com.h2database:h2'
  testimplementation 'org.springframework.boot:spring-boot-starter-test'
}

spring:
 datasource:
 url: jdbc:h2:mem:demodb
 username: sa
 password:
 hikari: # https://github.com/brettwooldridge/hikaricp (uses milliseconds for all time values)
 maximumpoolsize: 10
 minimumidle: 2
 idletimeout: 600000
 connectiontimeout: 30000
 maxlifetime: 1800000

package springbootguides.datasourceconfig;
 
import org.springframework.beans.factory.annotation.autowired;
import org.springframework.boot.commandlinerunner;
import org.springframework.boot.springapplication;
import org.springframework.boot.autoconfigure.springbootapplication;
 
import javax.sql.datasource;
import java.sql.connection;
 
@springbootapplication
public class datasourceconfigapplication implements commandlinerunner {
 
  @autowired
  private datasource datasource;
 
  @override
  public void run(string... args) throws exception {
    try(connection conn = datasource.getconnection()) {
      system.out.println(conn);
    }
  }
 
  public static void main(string[] args) {
    springapplication.run(datasourceconfigapplication.class, args);
  }
 
}

/**
   * hikari datasource configuration.
   */
  @conditionalonclass(hikaridatasource.class)
  @conditionalonmissingbean(datasource.class)
  @conditionalonproperty(name = "spring.datasource.type", havingvalue = "com.zaxxer.hikari.hikaridatasource", matchifmissing = true)
  static class hikari {
 
    @bean
    @configurationproperties(prefix = "spring.datasource.hikari")
    public hikaridatasource datasource(datasourceproperties properties) {
      hikaridatasource datasource = createdatasource(properties,
          hikaridatasource.class);
      if (stringutils.hastext(properties.getname())) {
        datasource.setpoolname(properties.getname());
      }
      return datasource;
    }
 
  }

implementation 'org.springframework.boot:spring-boot-starter-web'
implementation 'org.springframework.boot:spring-boot-starter-actuator'
implementation 'io.micrometer:micrometer-registry-prometheus'

management:
 endpoints:
 web:
  exposure:
  include: "health,info,prometheus"
 server:
 port: 8079
 servlet:
  context-path: /

curl http://localhost:8079/actuator/prometheus | grep hikari
# type hikaricp_connections_acquire_seconds summary
hikaricp_connections_acquire_seconds_count{pool="hikaripool-1",} 3.0
hikaricp_connections_acquire_seconds_sum{pool="hikaripool-1",} 0.001230082
# help hikaricp_connections_acquire_seconds_max connection acquire time
# type hikaricp_connections_acquire_seconds_max gauge
hikaricp_connections_acquire_seconds_max{pool="hikaripool-1",} 0.0
# help hikaricp_connections_min min connections
# type hikaricp_connections_min gauge
hikaricp_connections_min{pool="hikaripool-1",} 2.0
# type hikaricp_connections_timeout_total counter
hikaricp_connections_timeout_total{pool="hikaripool-1",} 0.0
# help hikaricp_connections_pending pending threads
# type hikaricp_connections_pending gauge
hikaricp_connections_pending{pool="hikaripool-1",} 0.0
# help hikaricp_connections_usage_seconds connection usage time
# type hikaricp_connections_usage_seconds summary
hikaricp_connections_usage_seconds_count{pool="hikaripool-1",} 3.0
hikaricp_connections_usage_seconds_sum{pool="hikaripool-1",} 0.06
# help hikaricp_connections_usage_seconds_max connection usage time
# type hikaricp_connections_usage_seconds_max gauge
hikaricp_connections_usage_seconds_max{pool="hikaripool-1",} 0.0
# help hikaricp_connections_max max connections
# type hikaricp_connections_max gauge
hikaricp_connections_max{pool="hikaripool-1",} 10.0
# help hikaricp_connections total connections
# type hikaricp_connections gauge
hikaricp_connections{pool="hikaripool-1",} 2.0
# help hikaricp_connections_creation_seconds_max connection creation time
# type hikaricp_connections_creation_seconds_max gauge
hikaricp_connections_creation_seconds_max{pool="hikaripool-1",} 0.0
# help hikaricp_connections_creation_seconds connection creation time
# type hikaricp_connections_creation_seconds summary
hikaricp_connections_creation_seconds_count{pool="hikaripool-1",} 1.0
hikaricp_connections_creation_seconds_sum{pool="hikaripool-1",} 0.001
# help hikaricp_connections_idle idle connections
# type hikaricp_connections_idle gauge
hikaricp_connections_idle{pool="hikaripool-1",} 2.0
# help hikaricp_connections_active active connections
# type hikaricp_connections_active gauge
hikaricp_connections_active{pool="hikaripool-1",} 0.0