MySql query slow and high CPU usage causing Jira stop responding

Lihang Cai August 28, 2022

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
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.
August 29, 2022

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

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 29, 2022

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