jmx编程监控mysql_Hikari连接池使用SpringBoot配置JMX监控

Hikari是SpringBoot 2.0中默认的连接池。

区别于c3p0直接通过连接池对象获取各项状态指标，Hikari需要通过JMX来获取。

示例代码如下，采用SpringBoot集成，定时采集连接池连接状态。@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:3306?serverTimezone=GMT");

hikaridatasource.setUsername("root");

hikaridatasource.setPassword("db10$ZTE");