db.conns.time.in.ms & db.reads.time.in.ms

Ed B. September 12, 2019

What are these? what each of these mean?  

If db.conns.time.in.ms is sporadically high, does it suggest DB Server or JDBC issues?

<form id="jira_request_timing_info" class="dont-default-focus" >

....

<input type="hidden" title="db.reads.time.in.ms" value="109" />
<input type="hidden" title="db.conns.time.in.ms" value="14593" />

...

</form>

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 12, 2019

These are not things most of us see in Jira, as most of us don't look at random bits of code out of context.  Could you explain where you are seeing this, what the actual fields look like and why you are looking at the code?

Ed B. September 16, 2019

hi @Nic Brough -Adaptavist- ,

 

Response to HTTP GET  http://jira.mydomain.com/browse/PROJECT-1234 contains these values in response body  For example 

`curl -XGET https://jira.atlassian.com/browse/JRASERVER-69948`

contains 

<form id="jira_request_timing_info" class="dont-default-focus" >

with hidden inputs for db.conns.time.in.ms, db.reads.time.in.ms 

<form id="jira_request_timing_info" class="dont-default-focus" >
<fieldset class="parameters hidden">
<input type="hidden" title="jira.request.start.millis" value="1568650648465" />
<input type="hidden" title="jira.request.server.time" value="107" />
<input type="hidden" title="jira.request.id" value="977x4084673x2" />
<input type="hidden" title="jira.session.expiry.time" value="-" />
<input type="hidden" title="jira.session.expiry.in.mins" value="-" />
<input id="jiraConcurrentRequests" type="hidden" name="jira.request.concurrent.requests" value="1" />
<input type="hidden" title="db.reads.time.in.ms" value="5" />
<input type="hidden" title="db.conns.time.in.ms" value="33" />
</fieldset>
</form>

 

I'm debugging an issue with  HTTP GETs  to  http://local-jira-instance/browse/PROJECT-1234  taking 10-30s with majority of jira.request.server.time spent in db.conns.time.in.ms .

 

Hope this clarifies where db.reads.time.in.ms and db.conns.time.in.ms come from.

Suggest an answer

Log in or Sign up to answer