Thread: Regarding the Spikes in the connection pool on our Database in the particular time period.
Regarding the Spikes in the connection pool on our Database in the particular time period.
From
Ramesh Penuballi
Date:
Dear Team,
![image.png](/media/maillist_attaches/pgsql-admin/2020/09/8/CAGeQtUvQYvRzF220jc27qrOWoU7L2Fqcn94ZJYU7fOauqM3t4A@mail.gmail.com/image.png)
![image.png](/media/maillist_attaches/pgsql-admin/2020/09/8/CAGeQtUvQYvRzF220jc27qrOWoU7L2Fqcn94ZJYU7fOauqM3t4A@mail.gmail.com/image-1.png)
We are facing an issue of sudden spikes in the connection pool in our Jira instance which is connected to our database server (RHEL) which is installed postgresql9.2 version.
Please find the below image which shows the increase in the connection pool..
![image.png](/media/maillist_attaches/pgsql-admin/2020/09/8/CAGeQtUvQYvRzF220jc27qrOWoU7L2Fqcn94ZJYU7fOauqM3t4A@mail.gmail.com/image.png)
These spikes are happening in our Jira instance at the particular timing of every day 10:30 AM IST -11:30 AM IST (i.e. 1AM EST-2AM EST) and it is causing the slowness of the applications.
To resolve the issue or to restor the connections , we have to restart the Jira services in the business hours which is impacting our business badly.
We have checked with the Atlassian team of Jira and they have confirmed that there are no issues at the application end and the database server is not processing the connections properly.
As per the suggestion from Atlassian support we have increased the CPU on the database server from 4 CPU to 8 CPU but we are still observing the spikes and causing the slowness of our Jira instance.
Currently our database server is having 8 CPU,16GB space and it is connecting to Jira instance.
Below are the CPU of the database server after increasing the CPU on 6th Sep 2020
![image.png](/media/maillist_attaches/pgsql-admin/2020/09/8/CAGeQtUvQYvRzF220jc27qrOWoU7L2Fqcn94ZJYU7fOauqM3t4A@mail.gmail.com/image-1.png)
From the above graph it clearly shows there is no load in the database after increasing the CPU's on the database server.
It would be great help, if you can help us find the root cause or any configuration changes which resolves the issue of increasing the connection pool.
Kindly let us know in case in case of any more information regarding the same.
Really appreciate the quick help on this as it is impacting our business so badly.
Thanks and Regards,
Ramesh
Attachment
Re: Regarding the Spikes in the connection pool on our Database in the particular time period.
From
Juan José Santamaría Flecha
Date:
On Tue, Sep 8, 2020 at 9:49 AM Ramesh Penuballi <ramesh.252@gmail.com> wrote:
We are facing an issue of sudden spikes in the connection pool in our Jira instance which is connected to our database server (RHEL) which is installed postgresql9.2 version.
This is a pretty old version of Postgres, at some point you should consider upgrading.
Please find the below image which shows the increase in the connection pool.
You should size the pool based on your busy hour, 20 connections are not that many, you can probably double that.
These spikes are happening in our Jira instance at the particular timing of every day 10:30 AM IST -11:30 AM IST (i.e. 1AM EST-2AM EST) and it is causing the slowness of the applications.
The amount of connections does not look like the source of the problem, but a symptom of slowness somewhere else. Can you log the slowest queries being executed during that time? Something like a pgbagder report would be very useful [1].
Regards,
Juan José Santamaría Flecha