1.Maven:
<dependency>
<groupId>p6spy</groupId>
<artifactId>p6spy</artifactId>
<version>3.8.1</version>
</dependency>
2.application.yml 配置:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.p6spy.engine.spy.P6SpyDriver
url: jdbc:p6spy:mysql://localhost:3306/aa?useUnicode=true&useSSL=false&characterEncoding=utf8
配置这个可能报错,解决办法:
application.yml 配置:
filters: config
max-file-size: 30MB【MB变为大写】
max-request-size: 30MB【MB变为大写】
3. 在rescource文件夹下新增一个文件【spy.properties】,配置如下:
- #3.2.1以上使用
modulelist=com.baomidou.mybatisplus.extension.p6spy.MybatisPlusLogFactory,com.p6spy.engine.outage.P6OutageFactory
#3.2.1以下使用或者不配置
#modulelist=com.p6spy.engine.loggi