Chris, I am getting the connection from the connection pool, defined using HikariCP.
What I have noticed is, as soon as database results are fetched I am printing it in the log, and I see there is a delay between when the results are printed in the log to that of the response received by the client (mobile or postman). If there is load test then I that this delay increases on the client side. I am using org.apache.coyote.http11.Http11NioProtocol for the connector. Is there any config which can be changed to reduce the delay to the client side ? --Ayub On Wed, Jun 16, 2021 at 12:22 AM Christopher Schultz < ch...@christopherschultz.net> wrote: > Ayub, > > On 6/15/21 11:33, Ayub Khan wrote: > > Would it be a cursor issue, as there seems to be how cursors are handled > in > > postgres and Oracle database. Below are the steps we take from jdbc side > > > > > > 1. open connection > > 2. set auto commit to false > > 3. create callable statement > > 4. execute the call > > 5. get the results > > 6. set autocommit to true > > 7. close the resultset,callable statement and connection > > Is this a read-only set of steps, or are you also writing anywhere in > there? How is your resource management? If you aren't going things > properly[1], it's definitely possible to tie your database up in knots. > > -chris > > [1] > > https://blog.christopherschultz.net/2009/03/16/properly-handling-pooled-jdbc-connections/ > > > On Thu, Jun 10, 2021 at 8:10 AM Ayub Khan <ayub...@gmail.com> wrote: > > > >> Seeing client write waits on postgresql as attached in the image. Is > there > >> any bottle neck which is causing the client write waits on postgresql ? > >> > >> Below is the test setup > >> > >> Jmeter-->(load balanced tomcat on ec2 instances)---->rds read replicas > >> > >> All these are running on different ec2 instances in AWS cloud in the > same > >> region > >> > >> below is the config of the http connector on tomcat: > >> > >> <Connector port="8080" > >> protocol="org.apache.coyote.http11.Http11NioProtocol" > >> connectionTimeout="120000" maxThreads="50000" > >> maxConnections="50000" > >> URIEncoding="UTF-8" > >> redirectPort="8443" /> > >> > >> Below are the specs of the server: > >> > >> Ec2 instance which is running tomcat 8.5 > >> > >> c5.9x large > >> 36 vpcu > >> 72GB memory > >> 10GBPS network > >> EBS band width 9500 > >> > >> > >> postgresql RDS db.r6g.16xlarge > >> > >> 512 GB memory > >> 64 VCPU > >> 25 Gibs network > >> AWS Gravitron cpu > >> > >> --Ayub > >> > >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > -- -------------------------------------------------------------------- Sun Certified Enterprise Architect 1.5 Sun Certified Java Programmer 1.4 Microsoft Certified Systems Engineer 2000 http://in.linkedin.com/pub/ayub-khan/a/811/b81 mobile:+966-502674604 ---------------------------------------------------------------------- It is proved that Hard Work and kowledge will get you close but attitude will get you there. However, it's the Love of God that will put you over the top!!
