[
https://issues.apache.org/jira/browse/DRILL-7466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7466:
------------------------------------
Description:
Drill does not allow the number of connections in the pool to configured
When a JDBC storage plugin is created, it creates 8 connections per plugin
which happen to be the default for dbcp connection pool. Currently, there is no
way to configure these parameters using storage configuration. Max Idle is set
to 8 leaving all connections open even when unused. This situation creates an
unnecessary connection to DB.
These parameters must be made configuration in the JDBC storage plugin
configuration.
*NOTE*
In DRILL-7639 BasicDataSource was replaced with Hikari, sourceParameters
sections remains and allows to configure data source, Hikari related
configuration properties should be used instead. List of Hikari properties:
https://github.com/brettwooldridge/HikariCP.
was:
Drill does not allow the number of connections in the pool to configured
When a JDBC storage plugin is created, it creates 8 connections per plugin
which happen to be the default for dbcp connection pool. Currently, there is no
way to configure these parameters using storage configuration. Max Idle is set
to 8 leaving all connections open even when unused. This situation creates an
unnecessary connection to DB.
These parameters must be made configuration in the JDBC storage plugin
configuration.
> Configurable number of connection in JDBC storage connection pool
> -----------------------------------------------------------------
>
> Key: DRILL-7466
> URL: https://issues.apache.org/jira/browse/DRILL-7466
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - JDBC
> Affects Versions: 1.17.0
> Reporter: Priyanka Bhoir
> Assignee: Arina Ielchiieva
> Priority: Major
> Fix For: 1.18.0
>
>
> Drill does not allow the number of connections in the pool to configured
> When a JDBC storage plugin is created, it creates 8 connections per plugin
> which happen to be the default for dbcp connection pool. Currently, there is
> no way to configure these parameters using storage configuration. Max Idle is
> set to 8 leaving all connections open even when unused. This situation
> creates an unnecessary connection to DB.
> These parameters must be made configuration in the JDBC storage plugin
> configuration.
> *NOTE*
> In DRILL-7639 BasicDataSource was replaced with Hikari, sourceParameters
> sections remains and allows to configure data source, Hikari related
> configuration properties should be used instead. List of Hikari properties:
> https://github.com/brettwooldridge/HikariCP.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
