Project

General

Profile

Forums » Help »

Slow queries for some users

Added by Mohamed Ghazi 2 days ago

Hello,

I recently migrated from Redmine 3 to 6.1 using Docker, and I’m experiencing performance issues for some users. When they try to open certain tickets or pages, the queries are very slow.

I checked the MySQL processlist, and some queries can take more than 5 minutes for those users, while for others (including myself) everything loads instantly.

We already tried to optimize the database by adding indexes and increasing performance-related settings, but the issue persists.

We are using three plugins: Agile, OAuth, and Resources.

Has anyone else experienced this issue? Thanks for your help.


Replies (1)

RE: Slow queries for some users - Added by Holger Just 1 day ago

Please provide more details. At least, please show which queries exactly are slow. You can get them either the database logs (e.g. MySQL's slow query log) or from Redmine's logs after increasing the log level.

    (1-1/1)