(→Database Connections (base.xml))
|
(→Database Connections (base.xml))
|
Line 116: | |||
--> | --> | ||
</bean> | </bean> | ||
- | <bean id="dataSource1" class="com.urbancode.anthill3.spring.DecryptPasswordDataSource" | + | </pre> |
- | destroy-method="close"> | ||
- | <property name="driverClassName"> | ||
- | <value>${install.db.driver}</value> | ||
- | </property> | ||
- | <property name="url"> | ||
- | <value>${install.db.url}</value> | ||
- | </property> | ||
- | <property name="username"> | ||
- | <value>${install.db.user}</value> | ||
- | </property> | ||
- | <property name="password"> | ||
- | <value>${install.db.password}</value> | ||
- | </property> | ||
- | <property name="maxActive"> | ||
- | <value>20</value> | ||
- | </property> | ||
- | <property name="maxIdle"> | ||
- | <value>20</value> | ||
- | </property> | ||
- | <property name="minIdle"> | ||
- | <value>20</value> | ||
- | </property> | ||
- | <property name="defaultTransactionIsolation"> | ||
- | <value>2</value> | ||
- | </property> | ||
- | <property name="testOnBorrow"> | ||
- | <value>true</value> | ||
- | </property> | ||
- | <property name="validationQuery"> | ||
- | <value>${install.db.validationQuery}</value> | ||
- | </property> | ||
- | <!-- not available in our version or the database connection pool library | ||
- | <property name="validationQueryTimeout"> | ||
- | <value>10</value> | ||
- | </property> | ||
- | --> | ||
- | <!-- track abandoned connections. this adds a overhead. only enable if connections are being leaked. | ||
- | <property name="logAbandoned"> | ||
- | <value>true</value> | ||
- | </property> | ||
- | <property name="removeAbandonedTimeout"> | ||
- | <value>300</value> | ||
- | </property> | ||
- | <property name="removeAbandoned"> | ||
- | <value>false</value> | ||
- | </property> | ||
- | --> | ||
- | </bean> | ||
- | <!-- DataSource used for identity generation so it does not create deadlocks --> | ||
- | <bean id="identityDataSource" class="com.p6spy.engine.spy.P6DataSource" destroy-method="close" scope="singleton"> | ||
- | <constructor-arg> | ||
- | <ref local="dataSource1"/> | ||
- | </constructor-arg> | ||
- | </bean></pre> | ||
= Linux Tunables For Increasing Threads & Sockets = | = Linux Tunables For Increasing Threads & Sockets = |