Springboot快速集成p6spy 监控SQL性能

Springboot快速集成p6spy 监控SQL性能

1.speak

.p6spy集成的方式有多种，这里只采用starter的方式进行快速集成

2.导入依赖

<dependency>
	<groupId>com.github.gavlyukovskiy</groupId>
	<artifactId>p6spy-spring-boot-starter</artifactId>
	<version>1.7.1</version>
</dependency>

3.配置

spring:
  application:
    name: p6spyDemo
  datasource:
	# driver-class-name:  com.mysql.cj.jdbc.Driver
    driver-class-name:  com.p6spy.engine.spy.P6SpyDriver #切换为p6spy
    username: root
    password: root
    url: jdbc:p6spy:mysql://localhost:3306/test
	type: com.alibaba.druid.pool.DruidDataSource

p6spy配置

# p6spy配置
decorator:
  datasource:
    p6spy:
      logging: file   #sysout为打印输出  #slf4j
      log-file: spy.log
      log-format: executionTime:%(executionTime) | sql:%(sqlSingleLine)