Slow response of Jira in JQL executions

[Alessandro Marino]

Not always but very often I am complained of extreme slowness in Jira's response to JQL executions. excluding delays of connection to the DB, does it also happen to you?

Example:
issuetype = Story AND "Feature Confluence Link" is not empty AND issueFunction in hasLinkType("User Story Related")

[Petr Vaníček · Accepted solution]

Hi,

which type of DB are you using? What about performance in other actions? What's your JVM values in setenv.sh?

[Alessandro Marino]

We have
- jira 7.13.1 on linux
- cpu: 16 virtual cpu
- Xms: 2048m (2 GB)
- Xmx: 20480m (20 GB)
- mysql 5.6.24

From system info we see (now) that we have "used memory" less than 5GB (free 15GB). Can it be a problem?

[Petr Vaníček]

I think you should set same value for max and min, you could try 8196m.

20 gigs is too much I think.

How many issues, projects,.. you have (stats in system info)?