We are on JIRA 6.1.7 and over a range of browsers (IE9, Chrome, Firefox) experiencing extremely slow issue searching. Searching for issues in the Navigator hang continuously and our jira-slow-queries.log is full of log messages. Nowhere have I been able to see how we can overcome these slow queries.
Our Environment is virtualised on VMWare.
4 CPU Cores (utilization running at around the 60% mark)
4GB RAM (JVM settings 1024 PermGen, with 2GB Min & Max)
CPU and Memory analysis from Java Melody do not show any particular strain on either of these.
The Disk Speed Tests came back as Good or Excellent using the JIRA support utility in the Knowledgebase article
The Database is MySQL and resides on the same server as JIRA.
The Database connection pools settings appear to be fine
We have implemented the Browse Projects permission for "Anyone"
Our JIRA has approx 70k issues, 160 projects, 250 custom fields, and any plugins we use (about 15) are the latest compatible ones for the version of JIRA we are running. It is connected to Active Directory, and we have the AD connector filter to return approx 1500 users and 12 groups.
Has anyone out there got any ideas on why our JIRA is running so slowly?
Regards