[jira] [Created] (DRILL-2526) Creating a JDBC connection can take upto 5 seconds

["Kunal Khatua (JIRA)" <ji...@apache.org>]

Kunal Khatua created DRILL-2526:
-----------------------------------

             Summary: Creating a JDBC connection can take upto 5 seconds
                 Key: DRILL-2526
                 URL: https://issues.apache.org/jira/browse/DRILL-2526
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 0.8.0
         Environment: RHEL 6.4

            Reporter: Kunal Khatua
             Fix For: 0.8.0, 0.9.0


Opening a JDBC connection to Drill takes unusually long. When the JVM opens the connection one after another, the time appears to be linear with a very small delta for each additional connection being opened. However, the initial connection cost is very high.

This is an example of various Client JVMs opening an increasing number of connections (source: Concurrency Testing)

concurrent_f1b59ed_SF100_20150321_1621.out:2015-03-21 16:22:38 [main] INFO  PipSQuawk initConnPool - Made 1 connections to DB in 5.309 sec
concurrent_f1b59ed_SF100_20150321_1644.out:2015-03-21 16:45:15 [main] INFO  PipSQuawk initConnPool - Made 2 connections to DB in 4.683 sec
concurrent_f1b59ed_SF100_20150321_1716.out:2015-03-21 17:17:00 [main] INFO  PipSQuawk initConnPool - Made 4 connections to DB in 4.618 sec
concurrent_f1b59ed_SF100_20150321_1807.out:2015-03-21 18:08:11 [main] INFO  PipSQuawk initConnPool - Made 8 connections to DB in 5.174 sec
concurrent_f1b59ed_SF100_20150321_1943.out:2015-03-21 19:44:13 [main] INFO  PipSQuawk initConnPool - Made 12 connections to DB in 5.318 sec
concurrent_f1b59ed_SF100_20150321_2107.out:2015-03-21 21:08:40 [main] INFO  PipSQuawk initConnPool - Made 16 connections to DB in 5.559 sec




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)