Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,370,123
Community Members
 
Community Events
168
Community Groups

MySql query slow and high CPU usage causing Jira stop responding

Hi there. We have encountered  a problem with Jira Software 8.13.4. We found a mysql query take a very long time (about 30 seconds to 1 minute) to execute, and it caused CPU usage extremely high. As a result, Jira almost stopped responding any request and we can only restart jira web app to temporarily make jira accessible.

The sql query log looks like this:

小新20220829-135934.jpg

Do you have any idea what's the purpose of this sql and how can we solve this slow query problem?

2 answers

0 votes

This looks like you might have an over-complex view set up in Big Picture.

0 votes

Hi @Lihang Cai ,

welcome to the Atlassian community!

First of all please check that your MySql version is supported (https://confluence.atlassian.com/adminjiraserver0813/supported-platforms-1027137429.html). After doing that please check your DBMS health.

Moreover check RAM settings for your JIRA App.

Try to restart your application.

Hope this helps,

Fabio

Suggest an answer

Log in or Sign up to answer