Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Ed B.
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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.
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
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
TAGS
AUG Leaders

Atlassian Community Events