drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2526) Creating a JDBC connection can take upto 5 seconds
Date Fri, 10 Apr 2015 17:45:12 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-2526:
----------------------------------
    Component/s: Client - JDBC

> 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
>          Components: Client - JDBC
>    Affects Versions: 0.8.0
>         Environment: RHEL 6.4
>            Reporter: Kunal Khatua
>             Fix For: 1.1.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)

Mime
View raw message