您好,登錄后才能下訂單哦!
由阿里巴巴開源的druid連接池是目前綜合實(shí)力最突出的數(shù)據(jù)庫(kù)連接池,而且還提供了監(jiān)控日志功能,能夠分析SQL執(zhí)行情況。
pom.xml中加入
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.21</version>
</dependency>
application.properties中加入
# druid
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
# 連接池初始化大小,最小,最大
spring.datasource.initialSize=10
spring.datasource.minIdle=10
spring.datasource.maxActive=30
# 連接等待超時(shí)時(shí)間
spring.datasource.maxWait=60000
# 多久檢測(cè)需要關(guān)閉的空閑連接
spring.datasource.timeBetweenEvictionRunsMillis=60000
# 一個(gè)連接在池中最小生存的時(shí)間
spring.datasource.minEvictableIdleTimeMillis=300000
# 校驗(yàn)SQL,Oracle配置 spring.datasource.validationQuery=SELECT 1 FROM DUAL,如果不配validationQuery項(xiàng),則下面三項(xiàng)配置無(wú)用
spring.datasource.validationQuery=SELECT 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
# 打開PSCache,并且指定每個(gè)連接上PSCache的大小
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
# 配置監(jiān)控統(tǒng)計(jì)攔截的filters,去掉后監(jiān)控界面sql無(wú)法統(tǒng)計(jì),wall用于防火墻
spring.datasource.filters=stat,wall,log4j
# 通過(guò)connectProperties屬性來(lái)打開mergeSql功能;慢SQL記錄
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
# 合并多個(gè)DruidDataSource的監(jiān)控?cái)?shù)據(jù)
spring.datasource.useGlobalDataSourceStat=true
注:之前已經(jīng)配置好了mysql,mybatis,這里沒(méi)有重復(fù)寫了
新增了一個(gè)DruidFilter.java來(lái)配置內(nèi)置的監(jiān)控
DruidFilter.java
package com.example.config;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class DruidFilter {
@Bean
public ServletRegistrationBean druidStatView() {
//指定路徑進(jìn)入內(nèi)置監(jiān)控頁(yè)面
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
//IP白名單:
servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
//IP黑名單
servletRegistrationBean.addInitParameter("deny", "192.168.1.73");
//登錄查看信息的賬號(hào)密碼.
//servletRegistrationBean.addInitParameter("loginUsername", "admin");
//servletRegistrationBean.addInitParameter("loginPassword", "123456");
//是否能夠重置數(shù)據(jù).
servletRegistrationBean.addInitParameter("resetEnable", "true");
return servletRegistrationBean;
}
@Bean
public FilterRegistrationBean druidWebStatFilter() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
//添加過(guò)濾規(guī)則.
filterRegistrationBean.addUrlPatterns("/*");
//添加不需要忽略的格式信息.
filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
return filterRegistrationBean;
}
}
注:我之前就已經(jīng)配置好了spring security,如果在和其他教程一樣配置druid的賬號(hào)密碼,會(huì)導(dǎo)致輸入druid的賬號(hào)密碼后無(wú)法跳轉(zhuǎn)進(jìn)入內(nèi)置監(jiān)控頁(yè)面,我知道有很多方法可以避免,但那都需要額外增加代碼來(lái)判斷繞過(guò),既然spring security已經(jīng)有了賬號(hào)權(quán)限,何必額外非得給druid單獨(dú)增加一套賬號(hào)權(quán)限,把 /druid/*
路徑配置在spring security中,公用已有的賬號(hào)權(quán)限不更好嘛。所以我沒(méi)有單獨(dú)配置。
還有這只是常用的配置,如若需要進(jìn)一步了解詳細(xì)的配置
內(nèi)置監(jiān)控頁(yè)面配置詳情,Web關(guān)聯(lián)配置詳情
效果圖如下
恩恩,還自帶阿里云的廣告,果然是阿里的開源產(chǎn)品
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。