High usage of database read/write

Question

Hi,

I have integrated my jira with external system, where i am running some scripts.

I am facing multiple issues.

1- When i am updating jira issue through script, its taking at least 5-10 seconds to reflect on jira issue.

2- I am receiving warnings of high usage.

Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=23/20

I am monitoring the db pool , the pool size is ok max size is 20 any i have active connects around 4-5 max. But the read/write is hitting the border line.

How can i fix this issue, where pool is ok but read/write is on border line. please guide

Nic Brough -Adaptavist- · Answer

Ok, you're going to need to look at everything that is happening at that time to see what the cause is.

Muhammad Ramzan_Atlassian Certified Master_ · Answer

Escalation service is still not scheduled,  i am running it manually in console as i was testing it.

I have few concerns/questions  and could not figure out

1- What could the reason after updating the issue status its reflecting after 5 seconds.

2-Active pool size showing in metric os normal but inside script console showing high connection pool logs

3-Read/write are high but active connections are normal

Nic Brough -Adaptavist- · Answer

Ok, so the spikes seem to repeat at 40 past the hour each hour, which suggests it's an hourly service.  Maybe the escalation job given that pattern?