You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/04/10 19:45:12 UTC
[jira] [Updated] (DRILL-2526) Creating a JDBC connection can take
upto 5 seconds
[ 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)