druid連接池的參數(shù)配置示例全面解析
更新時間：2023年09月28日 09:15:17 作者：codecraft
這篇文章主要為大家介紹了druid連接池的參數(shù)配置示例全面解析,有需要的朋友可以借鑒參考下,希望能夠有所幫助,祝大家多多進步,早日升職加薪
序
本文主要研究一下druid連接池的參數(shù)配置
DruidDataSourceFactory
druid-1.2.11-sources.jar!/com/alibaba/druid/pool/DruidDataSourceFactory.java
public class DruidDataSourceFactory implements ObjectFactory {
private static final Log LOG = LogFactory.getLog(DruidDataSourceFactory.class);
static final int UNKNOWN_TRANSACTIONISOLATION = -1;
public static final String PROP_DEFAULTAUTOCOMMIT = "defaultAutoCommit";
public static final String PROP_DEFAULTREADONLY = "defaultReadOnly";
public static final String PROP_DEFAULTTRANSACTIONISOLATION = "defaultTransactionIsolation";
public static final String PROP_DEFAULTCATALOG = "defaultCatalog";
public static final String PROP_DRIVERCLASSNAME = "driverClassName";
public static final String PROP_MAXACTIVE = "maxActive";
public static final String PROP_MAXIDLE = "maxIdle";
public static final String PROP_MINIDLE = "minIdle";
public static final String PROP_INITIALSIZE = "initialSize";
public static final String PROP_MAXWAIT = "maxWait";
public static final String PROP_TESTONBORROW = "testOnBorrow";
public static final String PROP_TESTONRETURN = "testOnReturn";
public static final String PROP_TIMEBETWEENEVICTIONRUNSMILLIS = "timeBetweenEvictionRunsMillis";
public static final String PROP_NUMTESTSPEREVICTIONRUN = "numTestsPerEvictionRun";
public static final String PROP_MINEVICTABLEIDLETIMEMILLIS = "minEvictableIdleTimeMillis";
public static final String PROP_PHY_TIMEOUT_MILLIS = "phyTimeoutMillis";
public static final String PROP_TESTWHILEIDLE = "testWhileIdle";
public static final String PROP_PASSWORD = "password";
public static final String PROP_URL = "url";
public static final String PROP_USERNAME = "username";
public static final String PROP_VALIDATIONQUERY = "validationQuery";
public static final String PROP_VALIDATIONQUERY_TIMEOUT = "validationQueryTimeout";
public static final String PROP_INITCONNECTIONSQLS = "initConnectionSqls";
public static final String PROP_ACCESSTOUNDERLYINGCONNECTIONALLOWED = "accessToUnderlyingConnectionAllowed";
public static final String PROP_REMOVEABANDONED = "removeAbandoned";
public static final String PROP_REMOVEABANDONEDTIMEOUT = "removeAbandonedTimeout";
public static final String PROP_LOGABANDONED = "logAbandoned";
public static final String PROP_POOLPREPAREDSTATEMENTS = "poolPreparedStatements";
public static final String PROP_MAXOPENPREPAREDSTATEMENTS = "maxOpenPreparedStatements";
public static final String PROP_CONNECTIONPROPERTIES = "connectionProperties";
public static final String PROP_FILTERS = "filters";
public static final String PROP_EXCEPTION_SORTER = "exceptionSorter";
public static final String PROP_EXCEPTION_SORTER_CLASS_NAME = "exception-sorter-class-name";
public static final String PROP_NAME = "name";
public static final String PROP_INIT = "init";
private static final String[] ALL_PROPERTIES = {
PROP_DEFAULTAUTOCOMMIT,
PROP_DEFAULTREADONLY,
PROP_DEFAULTTRANSACTIONISOLATION,
PROP_DEFAULTCATALOG,
PROP_DRIVERCLASSNAME,
PROP_MAXACTIVE,
PROP_MAXIDLE,
PROP_MINIDLE,
PROP_INITIALSIZE,
PROP_MAXWAIT,
PROP_TESTONBORROW,
PROP_TESTONRETURN,
PROP_TIMEBETWEENEVICTIONRUNSMILLIS,
PROP_NUMTESTSPEREVICTIONRUN,
PROP_MINEVICTABLEIDLETIMEMILLIS,
PROP_TESTWHILEIDLE,
PROP_PASSWORD,
PROP_FILTERS,
PROP_URL,
PROP_USERNAME,
PROP_VALIDATIONQUERY,
PROP_VALIDATIONQUERY_TIMEOUT,
PROP_INITCONNECTIONSQLS,
PROP_ACCESSTOUNDERLYINGCONNECTIONALLOWED,
PROP_REMOVEABANDONED,
PROP_REMOVEABANDONEDTIMEOUT,
PROP_LOGABANDONED,
PROP_POOLPREPAREDSTATEMENTS,
PROP_MAXOPENPREPAREDSTATEMENTS,
PROP_CONNECTIONPROPERTIES,
PROP_EXCEPTION_SORTER,
PROP_EXCEPTION_SORTER_CLASS_NAME,
PROP_INIT,
PROP_NAME,
"druid.timeBetweenLogStatsMillis",
"druid.stat.sql.MaxSize",
"druid.clearFiltersEnable",
"druid.resetStatEnable", //
"druid.notFullTimeoutRetryCount", //
"druid.maxWaitThreadCount", //
"druid.failFast", //
"druid.phyTimeoutMillis", //
"druid.wall.tenantColumn", //
"druid.wall.updateAllow", //
"druid.wall.deleteAllow", //
"druid.wall.insertAllow", //
"druid.wall.selelctAllow", //
"druid.wall.multiStatementAllow", //
};
//......
}DruidDataSourceFactory的ALL_PROPERTIES常量定義了所有支持的可配置項
DruidDataSourceWrapper
com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceWrapper.java
@ConfigurationProperties("spring.datasource.druid")
public class DruidDataSourceWrapper extends DruidDataSource implements InitializingBean {
@Autowired
private DataSourceProperties basicProperties;
@Override
public void afterPropertiesSet() throws Exception {
//if not found prefix 'spring.datasource.druid' jdbc properties ,'spring.datasource' prefix jdbc properties will be used.
if (super.getUsername() == null) {
super.setUsername(basicProperties.determineUsername());
}
if (super.getPassword() == null) {
super.setPassword(basicProperties.determinePassword());
}
if (super.getUrl() == null) {
super.setUrl(basicProperties.determineUrl());
}
if (super.getDriverClassName() == null) {
super.setDriverClassName(basicProperties.getDriverClassName());
}
}
@Autowired(required = false)
public void autoAddFilters(List<Filter> filters){
super.filters.addAll(filters);
}
/**
* Ignore the 'maxEvictableIdleTimeMillis < minEvictableIdleTimeMillis' validate,
* it will be validated again in {@link DruidDataSource#init()}.
*
* for fix issue #3084, #2763
*
* @since 1.1.14
*/
@Override
public void setMaxEvictableIdleTimeMillis(long maxEvictableIdleTimeMillis) {
try {
super.setMaxEvictableIdleTimeMillis(maxEvictableIdleTimeMillis);
} catch (IllegalArgumentException ignore) {
super.maxEvictableIdleTimeMillis = maxEvictableIdleTimeMillis;
}
}
}DruidDataSourceWrapper繼承了DruidDataSource，在afterPropertiesSet的時候會使用DataSourceProperties的username、password、url、driverClassName，其他配置在DruidDataSource中
DruidDataSource
com/alibaba/druid/pool/DruidDataSource.java
public class DruidDataSource extends DruidAbstractDataSource implements DruidDataSourceMBean, ManagedDataSource, Referenceable, Closeable, Cloneable, ConnectionPoolDataSource, MBeanRegistration {
private boolean useGlobalDataSourceStat = false;
private boolean logDifferentThread = true;
private volatile boolean keepAlive = false;
private boolean asyncInit = false;
protected boolean killWhenSocketReadTimeout = false;
protected boolean checkExecuteTime = false;
}DruidDataSource繼承了DruidAbstractDataSource，它只定義了keepAlive、asyncInit等幾個配置，其它大部分配置在DruidAbstractDataSource中
DruidAbstractDataSource
com/alibaba/druid/pool/DruidAbstractDataSource.java
public abstract class DruidAbstractDataSource extends WrapperAdapter implements DruidAbstractDataSourceMBean, DataSource, DataSourceProxy, Serializable {
protected volatile int initialSize = DEFAULT_INITIAL_SIZE;
public static final int DEFAULT_INITIAL_SIZE = 0;
protected volatile int maxActive = DEFAULT_MAX_ACTIVE_SIZE;
public static final int DEFAULT_MAX_ACTIVE_SIZE = 8;
protected volatile int minIdle = DEFAULT_MIN_IDLE;
public static final int DEFAULT_MIN_IDLE = 0;
protected volatile int maxIdle = DEFAULT_MAX_IDLE;
public static final int DEFAULT_MAX_IDLE = 8;
protected volatile long maxWait = DEFAULT_MAX_WAIT;
public static final int DEFAULT_MAX_WAIT = -1;
protected volatile String validationQuery = DEFAULT_VALIDATION_QUERY;
public static final String DEFAULT_VALIDATION_QUERY = null;
protected volatile int validationQueryTimeout = -1;
protected volatile boolean testOnBorrow = DEFAULT_TEST_ON_BORROW;
public static final boolean DEFAULT_TEST_ON_BORROW = false;
protected volatile boolean testOnReturn = DEFAULT_TEST_ON_RETURN;
public static final boolean DEFAULT_TEST_ON_RETURN = false;
protected volatile boolean testWhileIdle = DEFAULT_WHILE_IDLE;
public static final boolean DEFAULT_WHILE_IDLE = true;
protected volatile int maxPoolPreparedStatementPerConnectionSize = 10;
protected volatile long timeBetweenEvictionRunsMillis = DEFAULT_TIME_BETWEEN_EVICTION_RUNS_MILLIS;
public static final long DEFAULT_TIME_BETWEEN_EVICTION_RUNS_MILLIS = 60 * 1000L;
protected volatile int numTestsPerEvictionRun = DEFAULT_NUM_TESTS_PER_EVICTION_RUN;
public static final int DEFAULT_NUM_TESTS_PER_EVICTION_RUN = 3;
protected volatile long minEvictableIdleTimeMillis = DEFAULT_MIN_EVICTABLE_IDLE_TIME_MILLIS;
public static final long DEFAULT_MIN_EVICTABLE_IDLE_TIME_MILLIS = 1000L * 60L * 30L;
protected volatile long maxEvictableIdleTimeMillis = DEFAULT_MAX_EVICTABLE_IDLE_TIME_MILLIS;
public static final long DEFAULT_MAX_EVICTABLE_IDLE_TIME_MILLIS = 1000L * 60L * 60L * 7;
protected volatile long keepAliveBetweenTimeMillis = DEFAULT_TIME_BETWEEN_EVICTION_RUNS_MILLIS * 2;
protected volatile long phyTimeoutMillis = DEFAULT_PHY_TIMEOUT_MILLIS;
public static final long DEFAULT_PHY_TIMEOUT_MILLIS = -1;
protected volatile long timeBetweenConnectErrorMillis = DEFAULT_TIME_BETWEEN_CONNECT_ERROR_MILLIS;
public static final long DEFAULT_TIME_BETWEEN_CONNECT_ERROR_MILLIS = 500;
}DruidAbstractDataSource定義的配置及其默認值如下
| 類別 | 配置項 | 默認值 | 說明 |
|---|---|---|---|
| 數(shù)量 | initialSize | 0 | - |
| 數(shù)量 | maxActive | 8 | - |
| 數(shù)量 | minIdle | 0 | - |
| 數(shù)量 | maxIdle | 8 | - |
| 數(shù)量 | maxPoolPreparedStatementPerConnectionSize | 10 | - |
| 健康檢測 | validationQuery | null | mysql默認為SELECT 1 |
| 健康檢測 | validationQueryTimeout | -1 | 單位秒，mysql默認1s |
| 健康檢測 | testOnBorrow | false | - |
| 健康檢測 | testOnReturn | false | - |
| 健康檢測 | testOnReturn | false | - |
| 健康檢測 | testWhileIdle | true | - |
| evict | timeBetweenEvictionRunsMillis | 60s | - |
| evict | numTestsPerEvictionRun | 3 | - |
| evict | minEvictableIdleTimeMillis | 30分鐘 | - |
| evict | maxEvictableIdleTimeMillis | 7小時 | - |
| 超時 | maxWait | -1 | 單位毫秒 |
| 超時 | keepAliveBetweenTimeMillis | 120s | 2* DEFAULT_TIME_BETWEEN_EVICTION_RUNS_MILLIS |
| 超時 | phyTimeoutMillis | -1 | - |
| 超時 | queryTimeout | 0 | - |
| 超時 | transactionQueryTimeout | 0 | - |
| 錯誤 | timeBetweenConnectErrorMillis | 500ms | - |
| 連接泄露 | removeAbandoned | false | - |
| 連接泄露 | removeAbandonedTimeoutMillis | 300s | - |
獲取連接時，若maxWait大于0則走的pollLast(nanos)，其中maxWait是作為notEmpty.awaitNanos參數(shù)，毫秒轉(zhuǎn)為nacos，若為負數(shù)則取0；若maxWait小于等于0則走的takeLast，執(zhí)行的是notEmpty.await()，即阻塞等待
小結(jié)
druid連接池的配置主要是在DruidDataSource中，而DruidDataSource繼承了DruidAbstractDataSource，它只定義了keepAlive、asyncInit等幾個配置，其它大部分配置在DruidAbstractDataSource中，沒有單獨的一個配置類，然后默認只開啟了testWhileIdle，maxWait默認為-1；因而建議強制配置maxWait為正數(shù)(單位毫秒)；在并發(fā)量比較大的場景，若要保證連接池的穩(wěn)定數(shù)量則可以將minIdle配置為與maxIdle一樣。
以上就是druid連接池的參數(shù)配置示例全面解析的詳細內(nèi)容，更多關(guān)于druid連接池參數(shù)配置的資料請關(guān)注腳本之家其它相關(guān)文章！
相關(guān)文章
Spring IOC（控制反轉(zhuǎn)）實現(xiàn)依賴注入，將對象創(chuàng)建和依賴關(guān)系的管理交由Spring容器處理，通過注解或XML配置，實現(xiàn)對象之間的松耦合，提高代碼復(fù)用性和可維護性2023-04-04
SpringCloud?Feign集成AOP的常見問題與解決
在使用?Spring?Cloud?Feign?作為微服務(wù)通信的工具時,我們可能會遇到?AOP?不生效的問題,這篇文章將深入探討這一問題,給出幾種常見的場景,分析可能的原因,并提供解決方案,希望對大家有所幫助2023-10-10
內(nèi)存溢出是Java應(yīng)用開發(fā)中常見的問題,但通過合理的代碼優(yōu)化、內(nèi)存管理以及JVM參數(shù)調(diào)整,我們可以有效地避免和解決這類問題,這篇文章主要介紹了Java內(nèi)存溢出場景及解決辦法,需要的朋友可以參考下2024-04-04
這篇文章主要介紹了Java線程同步及實現(xiàn)方法詳解,當(dāng)我們有多個線程要同時訪問一個變量或?qū)ο髸r,如果這些線程中既有讀又有寫操作時,就會導(dǎo)致變量值或?qū)ο蟮臓顟B(tài)出現(xiàn)混亂,從而導(dǎo)致程序異常,需要的朋友可以參考下2023-11-11
這篇文章主要為大家詳細介紹了java實現(xiàn)簡易飛機大戰(zhàn)，文中示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下2022-05-05
Java代碼規(guī)范與質(zhì)量檢測插件SonarLint的使用
本文主要介紹了Java代碼規(guī)范與質(zhì)量檢測插件SonarLint的使用，文中通過示例代碼介紹的非常詳細，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2022-08-08
Java interrupt()方法使用注意_動力節(jié)點Java學(xué)院整理
這篇文章主要介紹了Java interrupt()方法使用注意_動力節(jié)點Java學(xué)院整理,需要的朋友可以參考下2017-05-05
這篇文章主要介紹了java多線程編程的相關(guān)資料，文中講解非常細致，幫助大家更好的理解和學(xué)習(xí)java多線程，感興趣的朋友可以了解下2020-08-08
這篇文章主要介紹了Java責(zé)任鏈模式定義與用法,結(jié)合具體實例分析了java責(zé)任鏈模式的功能、定義、使用方法、適用情況等,需要的朋友可以參考下2017-06-06
SpringBoot整合jasypt實現(xiàn)數(shù)據(jù)加密的步驟
聽說過jasypt嗎？它可是一個超級流行的Java庫哦,提供了簡單又高效的加密和解密接口,整合jasypt后,我們的SpringBoot應(yīng)用就能輕松處理敏感數(shù)據(jù)的加密和解密,而不必為復(fù)雜的加密算法頭疼啦,下面給大家介紹SpringBoot整合jasypt實現(xiàn)數(shù)據(jù)加密的步驟,感興趣的朋友一起看看吧2025-04-04