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测试数据/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测试数据mandlinerunner;

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