mysql (mariaDB) HikariCP 성능 튜닝

HikariCP 설정

spring:
    datasource:
      hikari:
        data-source-properties:
            cachePrepStmts: true
            prepStmtCacheSize: 250
            prepStmtCacheSqlLimit: 2048
            useServerPrepStmts: true
            useLocalSessionState: true
            rewriteBatchedStatements: true
            cacheResultSetMetadata: true
            cacheServerConfiguration: true
            elideSetAutoCommits: true
            maintainTimeStats: false

참조

---

• HikariCP MySQL-Configuration
• Connector/J Performance Gems slide