Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7466

Configurable number of connection in JDBC storage connection pool

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.18.0
    • Component/s: Storage - JDBC
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                priyankabhoir777@gmail.com Priyanka Bhoir
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: