[
https://issues.apache.org/jira/browse/DRILL-7639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7639:
------------------------------------
Description:
Hikari is much faster and more reliable than DBCP2.
See comparison and benchmarks:
https://beansroasted.wordpress.com/2017/07/29/connection-pool-analysis/
https://github.com/brettwooldridge/HikariCP
{{sourceParameters}} section will allow setting data source parameters listed
in https://github.com/brettwooldridge/HikariCP
Example:
{noformat}
"sourceParameters" : {
"minimumIdle" : 5,
"autoCommit": false,
"connectionTestQuery": "select * from information_schema.collations",
"dataSource.cachePrepStmts": true,
"prepStmtCacheSize": 250
}
{noformat}
Example of full configuration:
{noformat}
{
"type": "jdbc",
"driver": "org.postgresql.Driver",
"url": "jdbc:postgresql://localhost:5959/my_db?defaultRowFetchSize=2",
"username": "my_user",
"password": "my_pass",
"caseInsensitiveTableNames": false,
"sourceParameters": {
"autoCommit": false
},
"enabled": true
}
{noformat}
was:
Hikari is much faster and more reliable than DBCP2.
See comparison and benchmarks:
https://beansroasted.wordpress.com/2017/07/29/connection-pool-analysis/
https://github.com/brettwooldridge/HikariCP
{{sourceParameters}} section will allow setting data source parameters listed
in https://github.com/brettwooldridge/HikariCP.
{noformat}
"sourceParameters" : {
"minimumIdle" : 5,
"autoCommit": false,
"connectionTestQuery": "select * from information_schema.collations"
}
{noformat}
Example of full configuration:
{noformat}
{
"type": "jdbc",
"driver": "org.postgresql.Driver",
"url": "jdbc:postgresql://localhost:5959/my_db?defaultRowFetchSize=2",
"username": "my_user",
"password": "my_pass",
"caseInsensitiveTableNames": false,
"sourceParameters": {
"autoCommit": false
},
"enabled": true
}
{noformat}
> Replace DBCP2 with HikariCP in RDBMS (JDBC) plugin
> --------------------------------------------------
>
> Key: DRILL-7639
> URL: https://issues.apache.org/jira/browse/DRILL-7639
> Project: Apache Drill
> Issue Type: Task
> Affects Versions: 1.17.0
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
> Priority: Major
> Labels: doc-impacting, ready-to-commit
> Fix For: 1.18.0
>
>
> Hikari is much faster and more reliable than DBCP2.
> See comparison and benchmarks:
> https://beansroasted.wordpress.com/2017/07/29/connection-pool-analysis/
> https://github.com/brettwooldridge/HikariCP
> {{sourceParameters}} section will allow setting data source parameters listed
> in https://github.com/brettwooldridge/HikariCP
> Example:
> {noformat}
> "sourceParameters" : {
> "minimumIdle" : 5,
> "autoCommit": false,
> "connectionTestQuery": "select * from information_schema.collations",
> "dataSource.cachePrepStmts": true,
> "prepStmtCacheSize": 250
> }
> {noformat}
> Example of full configuration:
> {noformat}
> {
> "type": "jdbc",
> "driver": "org.postgresql.Driver",
> "url": "jdbc:postgresql://localhost:5959/my_db?defaultRowFetchSize=2",
> "username": "my_user",
> "password": "my_pass",
> "caseInsensitiveTableNames": false,
> "sourceParameters": {
> "autoCommit": false
> },
> "enabled": true
> }
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
