High usage of database read/write

[Muhammad Ramzan(Atlassian Certified Master)]

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-]

What is your script doing?

[Muhammad Ramzan(Atlassian Certified Master)]

I am running

4 scripted fields

One listener getting public comment with attachments and sending to external api.

If request failed ,creating one issue for that failure 

Executing escalation job every hour where getting some issues processing some requests and then updating the issue status and adding comments.

[Nic Brough -Adaptavist-]

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?

[Muhammad Ramzan(Atlassian Certified Master)]

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-]

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