[Java] HikariCP Connection Pool

링크: https://github.com/brettwooldridge/HikariCP

링크: https://github.com/brettwooldridge/HikariCP/wiki/Hibernate4

링크: https://github.com/brettwooldridge/HikariCP/wiki/MySQL-Configuration

링크: https://github.com/brettwooldridge/HikariCP/wiki/Spring-Hibernate

국내 링크: http://netframework.tistory.com/431

성능이 좋다는 말이 있다. 우선 테스트로 사용해 보고 판단하자.

Springframework datasource (context-datasource.xml)

<!-- HikariCP configuration -->
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown">
    <constructor-arg>
        <bean class="com.zaxxer.hikari.HikariConfig">
            <constructor-arg>
                <props>
                    <prop key="dataSource.url">jdbc:mysql://localhost/database</prop>
                    <prop key="dataSource.user">username</prop>
                    <prop key="dataSource.password">password</prop>
                    <prop key="dataSource.cachePrepStmts">true</prop>
                    <prop key="dataSource.prepStmtCacheSize">250</prop>
                    <prop key="dataSource.prepStmtCacheSqlLimit">2048</prop>
                    <prop key="dataSource.useServerPrepStmts">true</prop>
                </props>
            </constructor-arg>
            <property name="dataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" />
            <property name="minimumIdle" value="5" />
            <property name="maximumPoolSize" value="10" />
            <property name="connectionTestQuery" value="SELECT 1" />
            <property name="connectionTimeout"  value="300000" />
        </bean>
    </constructor-arg>
</bean>

Tomcat + Jndi (context.xml)

<Resource name="jdbc/myJndiName"
          auth="Container"
          factory="com.zaxxer.hikari.HikariJNDIFactory"
          type="javax.sql.DataSource"
          dataSourceClassName="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
          minimumIdle="5"
          maximumPoolSize="10"
          connectionTimeout="300000"
          connectionTestQuery="SELECT 1"

          dataSource.url="jdbc:mysql://localhost/database"
          dataSource.user="username"
          dataSource.password="password"
          dataSource.cachePrepStmts="true"
          dataSource.prepStmtCacheSize="250"
          dataSource.prepStmtCacheSqlLimit="2048"
          dataSource.useServerPrepStmts="true"
          />