第四章 第三节 各连接池配置参数比较

??????? 排版真心费劲，大家凑合看下吧，见谅~

?

?DruidDBCPC3P0Proxool数据库用户名称UsernameUsernameUser?数据库密码PasswordPasswordPassword?驱动名称DriverClassNameDriverClassNameDriverClassdriver-classJDBC连接串UrlUrlJdbcUrldriver-urlJDBC连接属性PropertiesPropertiesProperties?初始化大小InitialSizeInitialSizeInitialPoolSize?连接池最小空闲MinIdleMinIdleMinPoolSizeminimum-connection-count连接池最大空闲MaxIdleMaxIdle??连接池最大使用连接数量MaxActiveMaxActiveMaxPoolSizemaximum-connection-count最小逐出时间MinEvictableIdle
TimeMillisMinEvictableIdle
TimeMillismaxIdleTimehouse-keeping-
sleep-time最多等待线程MaxWaittdreadCountMaxWaittdreadCount??连接池增长步长??AcquireIncrement?获取连接时测试是否有效TestOnBorrowTestOnBorrowTestConnection
OnCheckouttest-before-use归还连接时是否测试有效TestOnReturnTestOnReturnTestConnection
OnCheckintest-after-use连接空闲时测试是否有效TestWhileIdleTestWhileIdle??测试有效用的SQL QueryValidationQueryValidationQueryPreferredTestQueryhouse-keeping-test-sql测试有效的超时时间ValidationQuery
TimeoutValidationQuery
Timeout??连接初始化SQLConnectionInitSqlsConnectionInitSqls??连接最大存活实现??MaxConnectionAge?连接泄漏的超时时间RemoveAbandoned
TimeoutRemoveAbandoned
TimeoutUnreturned
ConnectionTimeout?关闭泄漏的连接时打印堆栈信息LogAbandonedLogAbandonedDebugUnreturned
ConnectionStackTraces?逐出连接的检测时间间隔TimeBetween
EvictionRunsMillisTimeBetween
EvictionRunsMillisidleConnection
TestPeriod?Statement缓存大小MaxPoolPrepared
Statement
PerConnectionSizeMaxOpenPrepared
StatementsmaxStatements?获取连接最大等待时间maxWaitmaxWait??FatalException处理ExceptionSorter??fatal-sql-exception调用原生方法检测连接是否有效ValidConnection
CheckerClassName???连接出错时重试次数ConnectionError
RetryAttempts?acquireRetyrAttempts?连接出错时重试N次后退出breakAfter
AcquireFailure?breakAfter
AcquireFailure?检测未关闭Statement缺省打开，无法配置???获取连接等待统计NotEmptyWait???连接池扩展Filters???Statement执行超时时间QueryTimeout???事务隔离级别DefaultTransaction
IsolationDefaultTransaction
Isolation??ReadOnly设置DefaultReadOnlyDefaultReadOnly??AutoCommit设置DefaultAutoCommitDefaultAutoCommit??