Ayub, On 6/14/21 17:10, Ayub Khan wrote:
On Thu, 10 Jun 2021, 08:10 Ayub Khan, <[email protected]> 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 cpuIn jprofiler I see that the threads are waiting on reading the response from database side
If those threads are waiting, they shouldn't be using any CPU time at all. If they are all waiting on your database, it seems that your database is taking a long time to respond to requests.
With 50000 threads, maybe you are making too many requests against your (possibly underpowered) database to make any progress.
-chris --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
