Bad performance when creating an issue
Posted: 15 Sep 2016, 11:37
Hi,
We are working with Mantis v. 1.2.16 and we are having the problem that
when the users create/delete a new issue in Mantis they have to wait up to 1 min to get the control back.
I've chekced the threads on this but did not find a solution to my Problem. The table mantis_email_table is empty und the recipient list contains 10 users. We are not using the crontab (the variable $g_email_send_using_cronjob doesn't appear in the config file)
In the log I've noticed that the following lines:
15.09.2016 13:05 CEST filtering START NEW FILTER QUERY
15.09.2016 13:05 CEST filtering Simple Filter
15.09.2016 13:05 CEST filtering project_ids = @P61
15.09.2016 13:05 CEST filtering include sub-projects = 1
15.09.2016 13:05 CEST filtering Getting sub-projects for project id @P61
15.09.2016 13:05 CEST filtering project_ids after including sub-projects = @P61
15.09.2016 13:05 CEST filtering project_ids (with public/private access) = @P61
15.09.2016 13:05 CEST filtering project_ids (with public access) = @P
15.09.2016 13:05 CEST filtering project query = ( mantis_bug_table.project_id = 61 )
15.09.2016 13:05 CEST filtering no view_state query
15.09.2016 13:05 CEST filtering no reporter query
15.09.2016 13:05 CEST filtering handler query = ( mantis_bug_table.handler_id=0 )
15.09.2016 13:05 CEST filtering Join operator : AND
are repeated up to 10 times per second, forever. A restart of the Server as well as a restart of MySQL did not help.
Can anybody help on this?
Thanks in Advance
Paolo
We are working with Mantis v. 1.2.16 and we are having the problem that
when the users create/delete a new issue in Mantis they have to wait up to 1 min to get the control back.
I've chekced the threads on this but did not find a solution to my Problem. The table mantis_email_table is empty und the recipient list contains 10 users. We are not using the crontab (the variable $g_email_send_using_cronjob doesn't appear in the config file)
In the log I've noticed that the following lines:
15.09.2016 13:05 CEST filtering START NEW FILTER QUERY
15.09.2016 13:05 CEST filtering Simple Filter
15.09.2016 13:05 CEST filtering project_ids = @P61
15.09.2016 13:05 CEST filtering include sub-projects = 1
15.09.2016 13:05 CEST filtering Getting sub-projects for project id @P61
15.09.2016 13:05 CEST filtering project_ids after including sub-projects = @P61
15.09.2016 13:05 CEST filtering project_ids (with public/private access) = @P61
15.09.2016 13:05 CEST filtering project_ids (with public access) = @P
15.09.2016 13:05 CEST filtering project query = ( mantis_bug_table.project_id = 61 )
15.09.2016 13:05 CEST filtering no view_state query
15.09.2016 13:05 CEST filtering no reporter query
15.09.2016 13:05 CEST filtering handler query = ( mantis_bug_table.handler_id=0 )
15.09.2016 13:05 CEST filtering Join operator : AND
are repeated up to 10 times per second, forever. A restart of the Server as well as a restart of MySQL did not help.
Can anybody help on this?
Thanks in Advance
Paolo