{"action":"created","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/352","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/352/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/352/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/352/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/352","id":96610399,"number":352,"title":"HikariDataSource.getConnection is slow under load","user":{"login":"kpadmasola","id":1274758,"avatar_url":"https://avatars.githubusercontent.com/u/1274758?v=3","gravatar_id":"","url":"https://api.github.com/users/kpadmasola","html_url":"https://github.com/kpadmasola","followers_url":"https://api.github.com/users/kpadmasola/followers","following_url":"https://api.github.com/users/kpadmasola/following{/other_user}","gists_url":"https://api.github.com/users/kpadmasola/gists{/gist_id}","starred_url":"https://api.github.com/users/kpadmasola/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kpadmasola/subscriptions","organizations_url":"https://api.github.com/users/kpadmasola/orgs","repos_url":"https://api.github.com/users/kpadmasola/repos","events_url":"https://api.github.com/users/kpadmasola/events{/privacy}","received_events_url":"https://api.github.com/users/kpadmasola/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-07-22T16:31:39Z","updated_at":"2015-08-07T07:39:39Z","closed_at":null,"body":"Hi Brett,\r\n\r\nI recompiled the application with 2.3.10-SNAPSHOT. I enabled coda hale metrics, set JVM argument -Dcom.zaxxer.hikari.aliveBypassWindow=5000. I ran 2 simulations, one with a pool size of 7 and another with a pool size of 22 on my laptop. The JMX metrics graphs are attached.\r\n\r\nPlease let me know if you need more details.\r\n\r\nsimulation details:\r\n40 concurrent users, over 5 minutes\r\n\r\nwith poolsize of 7:\r\nSummary statistics from gatling perf tool\r\n![summary](https://cloud.githubusercontent.com/assets/1274758/8830977/ff534df4-30bc-11e5-8be4-776ddec699d9.PNG)\r\n\r\nWait\r\n![wait](https://cloud.githubusercontent.com/assets/1274758/8830536/53ce692a-30ba-11e5-933a-567e68691530.PNG)\r\nactiveConnections\r\n![activeconnections](https://cloud.githubusercontent.com/assets/1274758/8830538/53dcc13c-30ba-11e5-93d2-94ee19ec7e92.PNG)\r\nidleconnections\r\n![idleconnections](https://cloud.githubusercontent.com/assets/1274758/8830537/53dabd2e-30ba-11e5-9bea-5b9b7fd39f8c.PNG)\r\npendingconnections\r\n![pendingconnections](https://cloud.githubusercontent.com/assets/1274758/8830539/53e1382a-30ba-11e5-82d2-c3d50848c2fb.PNG)\r\ntotalconnections\r\n![totalconnections](https://cloud.githubusercontent.com/assets/1274758/8830540/53e19158-30ba-11e5-8535-96a11980a192.PNG)\r\nusage\r\n![usage](https://cloud.githubusercontent.com/assets/1274758/8830541/53e4ec7c-30ba-11e5-9b5a-22c1d91818bb.PNG)\r\n\r\nwith poolsize of 22:\r\nSummary statistics from gatling perf tool\r\n![summary](https://cloud.githubusercontent.com/assets/1274758/8831004/188ee76a-30bd-11e5-9a8d-112dd5ee74fd.PNG)\r\n\r\nwait\r\n![wait](https://cloud.githubusercontent.com/assets/1274758/8830621/cb181814-30ba-11e5-9797-361568d02664.PNG)\r\nactiveconnections\r\n![activeconnections](https://cloud.githubusercontent.com/assets/1274758/8830622/cb1f4b52-30ba-11e5-98b5-d650a81c3cc8.PNG)\r\nidleconnections\r\n![idleconnections](https://cloud.githubusercontent.com/assets/1274758/8830623/cb211234-30ba-11e5-8cd6-90d6026f329b.PNG)\r\npendingconnections\r\n![pendingconnections](https://cloud.githubusercontent.com/assets/1274758/8830625/cb256578-30ba-11e5-9143-596220687220.PNG)\r\ntotalconnections\r\n![totalconnections](https://cloud.githubusercontent.com/assets/1274758/8830624/cb246a9c-30ba-11e5-9505-9fd831b52b0f.PNG)\r\nusage\r\n![usage](https://cloud.githubusercontent.com/assets/1274758/8830626/cb2b2af8-30ba-11e5-941e-4741ee5121f8.PNG)\r\n\r\nthanks,\r\nKrishna\r\nPS: this thread is continued from HikariCP Google Groups thread https://groups.google.com/forum/#!topic/hikari-cp/lLabMIN6PEY\r\n\r\nOn Wednesday, July 22, 2015 at 1:26:11 PM UTC+5:30, Brett Wooldridge wrote:\r\nHi Krishna,\r\n\r\nEven for the Java 6/7 jars you must use Java 8 to build.  You can use any version at runtime, but the build itself requires Java 8.\r\n\r\nYou can also download the 2.3.10-SNAPSHOT JAR file directly from here."},"comment":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/comments/128624035","html_url":"https://github.com/brettwooldridge/HikariCP/issues/352#issuecomment-128624035","issue_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/352","id":128624035,"user":{"login":"kpadmasola","id":1274758,"avatar_url":"https://avatars.githubusercontent.com/u/1274758?v=3","gravatar_id":"","url":"https://api.github.com/users/kpadmasola","html_url":"https://github.com/kpadmasola","followers_url":"https://api.github.com/users/kpadmasola/followers","following_url":"https://api.github.com/users/kpadmasola/following{/other_user}","gists_url":"https://api.github.com/users/kpadmasola/gists{/gist_id}","starred_url":"https://api.github.com/users/kpadmasola/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kpadmasola/subscriptions","organizations_url":"https://api.github.com/users/kpadmasola/orgs","repos_url":"https://api.github.com/users/kpadmasola/repos","events_url":"https://api.github.com/users/kpadmasola/events{/privacy}","received_events_url":"https://api.github.com/users/kpadmasola/received_events","type":"User","site_admin":false},"created_at":"2015-08-07T07:39:39Z","updated_at":"2015-08-07T07:39:39Z","body":"Hi Brett,\r\n\r\nI upgraded to the latest driver and set the properties suggested by you, but there is no improvement. Here's the relevant section from a new relic profile snapshot which shows connection acquisition taking about 9% for one db transaction.  Does this provide a clue to where the bottleneck is and how it can be avoided?\r\n\r\n![hikari-get-connection](https://cloud.githubusercontent.com/assets/1274758/9130982/eb3ab416-3d04-11e5-8165-41b5fdc5f61d.PNG)\r\n\r\nthanks,\r\nKrishna"}}