HikariCP监控

若需要监控数据库连接池设置是否合理, 需要能监控到连接池对应的指标, 具体如何操作，可依据以下进行配置。.

增加依赖

<dependency>
	<groupId>io.dropwizard.metrics</groupId>
	<artifactId>metrics-core</artifactId>
	<version>4.0.7</version>
</dependency>

增加配置类

    private static final Logger LOGGER = LoggerFactory.getLogger(DataSourceConfig.class);

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.hikari")
    public HikariDataSource dataSource(DataSourceProperties properties){
        HikariDataSource dataSource = properties.initializeDataSourceBuilder()
                .type(HikariDataSource.class)
                .build();
        dataSource.setMetricRegistry(initMetricRegistry("HikariPool-1"));
        return dataSource;
    }

    public MetricRegistry initMetricRegistry(String poolName) {
        MetricRegistry metricRegistry = new MetricRegistry();
        Slf4jReporter reporter = Slf4jReporter.forRegistry(metricRegistry)
                .filter((name, metric) -> name.startsWith(poolName + ".pool"))
                .outputTo(LOGGER)
                .convertRatesTo(TimeUnit.SECONDS)
                .convertDurationsTo(TimeUnit.MILLISECONDS)

                .build();
        reporter.start(1, TimeUnit.SECONDS);//1秒打印一次
        return metricRegistry;
    }