首页
学习
活动
专区
圈层
工具
发布

SpringBoot整合Druid Monitor监控服务

Druid是一个非常好用的数据库连接池,但是他的好并不止体现在作为一个连接池加快数据访问性能上和连接管理上,他带有一个强大的监控工具:Druid Monitor。不仅可以监控数据源和慢查询,还可以监控Web应用、URI监控、Session监控、Spring监控。

1.添加依赖

代码语言:html
复制
<!--druid-spring-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.10</version>
</dependency>

2.配置文件

代码语言:yaml
复制
spring:
  # Druid数据源配置(Oracle版本)
  datasource:
    url: jdbc:oracle:thin:@www.jyglxt.com:1521:xe
    username: JYGLXT
    password: oracle
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: oracle.jdbc.driver.OracleDriver
    druid:
      max-active: 100
      initial-size: 3
      min-idle: 3
      max-wait: 30000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 30000
      pool-prepared-statements: true
      max-open-prepared-statements: 30
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      filter:
        wall:
          enabled: true
        stat:
          enabled: true
          log-slow-sql: true
          slow-sql-millis: 10000
          merge-sql: true
      web-stat-filter:
        enabled: true
        url-pattern: /*
        exclusions: /*.js,/*.gif,/*.jpg,/*.bmp,/*.png,/*.css,/*.ico,/druid/*
        session-stat-enable: true
        profile-enable: true
      stat-view-servlet:
        login-password: caixibei
        login-username: caixibei

3.启动类修改

代码语言:java
复制
@SpringBootApplication(scanBasePackages = "cn.jxd.caixibei")
@ComponentScan(basePackages = "cn.jxd.caixibei")
@MapperScan(basePackages = "cn.jxd.caixibei.mapper")
@EnableOpenApi
@Slf4j
public class JyglxtApplication {
    public static void main(String[] args) {
        ConfigurableApplicationContext context = SpringApplication.run(JyglxtApplication.class, args);
        Environment environment = context.getBean(Environment.class);
        log.info("---------------------------------------------------------");
        log.info("系统访问路径:http://localhost:"+environment.getProperty("server.port")+"/jyglxt/index/");
        log.info("Swagger访问路径:http://localhost:"+environment.getProperty("server.port")+"/swagger-ui/");
        log.info("WebSocket测试路径:ws://localhost:"+environment.getProperty("server.port")+"/ws/api/10/");
        log.info("SQL监控平台:http://localhost:"+environment.getProperty("server.port")+"/druid/");
        log.info("---------------------------------------------------------");
    }
}

启动类其实没动啥,就是把访问地址打印了一下.🤣

下一篇
举报
领券