add 集成 性能分析插件 p6spy 更强劲的 SQL 分析

疯狂的狮子li

2021-08-05 8c912a81331f46c929b7d3107f2ff383c042ea35

add 集成 性能分析插件 p6spy 更强劲的 SQL 分析

 pom.xml

@@ -26,6 +26,7 @@
        <velocity.version>1.7</velocity.version>
        <jwt.version>0.9.1</jwt.version>
        <mybatis-plus.version>3.4.3</mybatis-plus.version>
        <p6spy.version>3.9.1</p6spy.version>
        <hutool.version>5.7.6</hutool.version>
        <feign.version>3.0.3</feign.version>
        <feign-okhttp.version>11.2</feign-okhttp.version>
@@ -118,6 +119,12 @@
                <artifactId>mybatis-plus-extension</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            <!-- sql性能分析插件 -->
            <dependency>
                <groupId>p6spy</groupId>
                <artifactId>p6spy</artifactId>
                <version>${p6spy.version}</version>
            </dependency>

            <dependency>
                <groupId>cn.hutool</groupId>

 ruoyi-admin/src/main/resources/application-dev.yml

@@ -4,7 +4,9 @@
    type: com.alibaba.druid.pool.DruidDataSource
    # åŠ¨æ€æ•°æ®æºæ–‡æ¡£ https://www.kancloud.cn/tracy5546/dynamic-datasource/content
    dynamic:
      #设置默认的数据源或者数据源组,默认值即为 master
      # æ€§èƒ½åˆ†æžæ’件(有性能损耗 ä¸å»ºè®®ç”Ÿäº§çŽ¯å¢ƒä½¿ç”¨)
      p6spy: true
      # è®¾ç½®é»˜è®¤çš„数据源或者数据源组,默认值即为 master
      primary: master
      datasource:
        # ä¸»åº“数据源

 ruoyi-admin/src/main/resources/application-prod.yml

@@ -4,7 +4,9 @@
    type: com.alibaba.druid.pool.DruidDataSource
    # åŠ¨æ€æ•°æ®æºæ–‡æ¡£ https://www.kancloud.cn/tracy5546/dynamic-datasource/content
    dynamic:
      #设置默认的数据源或者数据源组,默认值即为 master
      # æ€§èƒ½åˆ†æžæ’件(有性能损耗 ä¸å»ºè®®ç”Ÿäº§çŽ¯å¢ƒä½¿ç”¨)
      p6spy: false
      # è®¾ç½®é»˜è®¤çš„数据源或者数据源组,默认值即为 master
      primary: master
      datasource:
        # ä¸»åº“数据源

 ruoyi-admin/src/main/resources/application.yml

@@ -162,8 +162,10 @@
    localCacheScope: SESSION
    # å¼€å¯Mybatis二级缓存，默认为 true
    cacheEnabled: false
    # æ›´è¯¦ç»†çš„日志输出 ä¼šæœ‰æ€§èƒ½æŸè€—
    # logImpl: org.apache.ibatis.logging.stdout.StdOutImpl
    # æ›´è¯¦ç»†çš„日志输出 ä¼šæœ‰æ€§èƒ½æŸè€— org.apache.ibatis.logging.stdout.StdOutImpl
    # å…³é—­æ—¥å¿—记录 (可单纯使用 p6spy åˆ†æž) org.apache.ibatis.logging.nologging.NoLoggingImpl
    # é»˜è®¤æ—¥å¿—输出 org.apache.ibatis.logging.slf4j.Slf4jImpl
    logImpl: org.apache.ibatis.logging.nologging.NoLoggingImpl
  global-config:
    # æ˜¯å¦æ‰“印 Logo banner
    banner: true

 ruoyi-admin/src/main/resources/spy.properties

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,26 @@
# p6spy æ€§èƒ½åˆ†æžæ’件配置文件
modulelist=com.baomidou.mybatisplus.extension.p6spy.MybatisPlusLogFactory,com.p6spy.engine.outage.P6OutageFactory
# è‡ªå®šä¹‰æ—¥å¿—打印
logMessageFormat=com.baomidou.mybatisplus.extension.p6spy.P6SpyLogger
#日志输出到控制台
appender=com.baomidou.mybatisplus.extension.p6spy.StdoutLogger
# ä½¿ç”¨æ—¥å¿—系统记录 sql
#appender=com.p6spy.engine.spy.appender.Slf4JLogger
# è®¾ç½® p6spy driver ä»£ç†
#deregisterdrivers=true
# å–消JDBC URL前缀
useprefix=true
# é…ç½®è®°å½• Log ä¾‹å¤–,可去掉的结果集有error,info,batch,debug,statement,commit,rollback,result,resultset.
excludecategories=info,debug,result,commit,resultset
# æ—¥æœŸæ ¼å¼
dateformat=yyyy-MM-dd HH:mm:ss
# å®žé™…驱动可多个
#driverlist=org.h2.Driver
# æ˜¯å¦å¼€å¯æ…¢SQL记录
outagedetection=true
# æ…¢SQL记录标准 2 ç§’
outagedetectioninterval=2
# æ˜¯å¦è¿‡æ»¤ Log
filter=true
# è¿‡æ»¤ Log æ—¶æ‰€æŽ’除的表名列表，以逗号分隔
exclude=QRTZ_

 ruoyi-common/pom.xml

@@ -152,6 +152,11 @@
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
        </dependency>
        <!-- sql性能分析插件 -->
        <dependency>
            <groupId>p6spy</groupId>
            <artifactId>p6spy</artifactId>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>