Too many accesses to JIRA database

[Begoña Bonet]

We have detected that there are too many accesses (several milions of times per week) to our JIRA database made for the query:

SELECT COUNT(I.ID) 

FROM jiraissue I 
WHERE I.PROJECT=:1 AND I.ASSIGNEE=:2       

We don't have any customfield based on this query, thus we have supposed there is due to any specific gadget in a Dashboard. 

Any idea?

[Begoña Bonet · Accepted solution]

Finally it seems that our problem was related with https://jira.atlassian.com/browse/JRA-36699

[teilor_soares]

Hi Begoña! I have a few ideas, most from similar issues I saw in the past. I suggest to you to check the 3 things below.

1. Your REST calls. We have a documented bug (JRA-34412) about this.
2. Large number of projects and customfields (JRA-25721)
3. Check if the problem does not happen only when you are navigating in projects with Issue-level security. I saw a few reports about this kind of query running a lot when a user is navigating in this projects.

I hope my ideas help you on finding the root cause of this problem, but if they don't, and this queries start to affect the performance of your JIRA instance, I recommend to you to create a ticket to our support team in support.atlassian.com

Cheers!
Teilor

[Begoña Bonet]

Thanks Teilor! I'll check this 3 points!!!!