mysql (mariaDB) HikariCP 성능 튜닝

mysql (mariaDB) HikariCP 성능 튜닝

HikariCP 설정

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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

참조