Hikari 目前是 SpringBoot 默认的连接池。
区别于 c3p0 直接通过连接池对象获取各项状态指标,Hikari需要通过JMX来获取。
示例代码如下, SpringBoot 集成,定时采集 Hikari 连接池 连接状态 。
@Component
@Controller
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
@EnableScheduling
public class HikariTest {
private static HikariPoolMXBean poolProxy;
private static final Logger log = LoggerFactory.getLogger(HikariTest.class);
public static void main(String[] args) throws SQLException, MalformedObjectNameException, InterruptedException {
SpringApplication.run(HikariTest.class, args);
HikariDataSource hikaridatasource = new HikariDataSource();
hikaridatasource.setJdbcUrl("jdbc:mysql://localhost:3