将执行的sql超过设置时间的找出来,以便于知道优化哪些sql
application.properties ,100表示时间,单位毫秒
#spring.datasource.druid.filter.stat.enabled=true 部署数据源默认打开可不配置
spring.datasource.druid.filter.stat.log-slow-sql=true
spring.datasource.druid.filter.stat.slow-sql-millis=100
application.yml:最后一条配置
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@192.168.xxx.xxx:1521:orcl
#SqlServer
#driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
#url: jdbc:sqlserver://localhost:1433;DatabaseName=test
username: xxx
password: xxx
# 下面为连接池的补充设置,应用到上面所有数据源中
druid:
# 配置测试查询语句 orcle:select 1 from dual sqlserver mysql SELECT 1
validationQuery: select 1 from dual
# 初始化大小,最小,最大
initialSize: 10
minIdle: 10
maxActive: 200
# 配置一个连接在池中最小生存的时间,单位是毫秒
minEvictableIdleTimeMillis: 180000
testOnBorrow: false
testWhileIdle: true
removeAbandoned: true
removeAbandonedTimeout: 1800
logAbandoned: true
# 打开PSCache,并且指定每个连接上PSCache的大小
poolPreparedStatements: true
maxOpenPreparedStatements: 100
# 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙
filters: stat,wall
# 通过connectProperties属性来打开mergeSql功能;慢SQL记录
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=1