Page 1 of 2

Mantis is slow

Posted: 18 Sep 2018, 07:05
by shanthini
We are using Mantis (Version: 2.15.0) for reporting bugs for the past few years. Reccentrly this seems to be very slow (Takes 30 to 40 seconds to close an issue). Currently the DB has nearly 60000 issues and 140 project.

Could you please suggest for a fix

Thanks

Re: Mantis is slow

Posted: 18 Sep 2018, 09:26
by atrol
How long does it take to view a single issue?
When did it start to be slow?

Re: Mantis is slow

Posted: 18 Sep 2018, 10:51
by shanthini
Thanks. This is taking 30 to 40 seconds to close an issue

Re: Mantis is slow

Posted: 18 Sep 2018, 10:53
by shanthini
Just now we noted that the RAM size is 512MB. Now we increased to 2GB. Hope it will work hereafter without issues.

Re: Mantis is slow

Posted: 19 Sep 2018, 08:02
by shanthini
Hi atrol

After increasing the RAM also we are facing the same issue. We are using Mantis in our local network for reporting bugs. The DB size is 4.7GB. Currently the DB has nearly 60000 issues and 140 project.

Could you please suggest: Cane we disable the projects that are not in use to resolve this issue

Thanks

Re: Mantis is slow

Posted: 20 Sep 2018, 06:47
by atrol
As a first step, you should answer my questions
atrol wrote: ↑18 Sep 2018, 09:26 How long does it take to view a single issue?
When did it start to be slow?
And some more questions:
Have you installed any plugins?
Do you use any custom functions?
Which PHP version, database version, operating system version do you use?


As a side note:
I assume your database size is quite hug because you store attachments in it.
You might consider to store attachments on filesystem.
But I do not expect that this will influence your performance issue.

Re: Mantis is slow

Posted: 20 Sep 2018, 07:38
by shanthini
Please find answers. I have attached the DB stats herewith. Thanks

How long does it take to view a single issue?
We are not facing issues while viewing

When did it start to be slow?
Takes more than a minute (Select two issues and closed in one shot)
6.55.17 AM– Close button hit
6.56.33 AM- Completed

Takes more than 40 seconds (Select a single issues and closed)
6.59.28 AM – Close button hit
7.00.11 AM - Completed


Have you installed any plugins?
The plugins installed are: Avatars via Gravatar 2.15.0, Import/Export issues 2.15.0, Mantis Graphs 2.15.0, MantisBT Core 2.15.0

Do you use any custom functions?
No

Which PHP version, database version, operating system version do you use?
PHP 5.5
MySQL 5.6
Windows server 2008 R2 Enterprise

Re: Mantis is slow

Posted: 20 Sep 2018, 07:42
by shanthini
Attached the DB stats herewith

Re: Mantis is slow

Posted: 20 Sep 2018, 09:13
by atrol
The questions
When did it start to be slow?
is not meant that way.
Is it slow since yesterday, or last week, or last month ...?
When was it slow the first time?

Concernings Db statistics.
Your last rows shows "newrecords".
This is no Mantis table.
What is it?

Re: Mantis is slow

Posted: 20 Sep 2018, 09:52
by shanthini
Hi

When did it start to be slow?
-- Not sure exatctly, we are facing slowness from last week.

About 'newrecords' table
-- We are not using that table. I will delete that. By mistake this may be created

Thanks

Re: Mantis is slow

Posted: 21 Sep 2018, 07:28
by atrol
Do you see a high CPU usage of any process in task manager of the server when closing an issue?

Is closing issue also slow when temporary deactivating e-mail notifications?
Add the following line to config_inc.php for it.

Code: Select all

$g_enable_email_notification	= OFF;

Re: Mantis is slow

Posted: 26 Sep 2018, 10:46
by shanthini
Dear Atrol,

When we included this line '$g_enable_email_notification = OFF;' we do not face the performance related issue and this is working fine. Actually we need to send mail notifications also. Could you please suggest on this.

Thanks

Re: Mantis is slow

Posted: 26 Sep 2018, 11:46
by cas
You can configure mantis to send out the mails using a cron job (linux) or a task (windows).
There is plenty of documentation around that process available.

Re: Mantis is slow

Posted: 27 Sep 2018, 04:02
by shanthini
Hi,

Thanks for your support

We have configured the script available in 'send_emails.php' inside 'scripts' folder using scheduler. Please suggest whether I need to set both

$g_enable_email_notification = ON;
$g_email_send_using_cronjob = ON;

We are using windows task scheduer for this

Re: Mantis is slow

Posted: 27 Sep 2018, 04:13
by shanthini
I tried this by below setting. Mails sending is working fine. But the performance issue still persists (loading slowly)

$g_enable_email_notification = ON;
$g_email_send_using_cronjob = ON;

I tried this by below setting. Mails sending is not working. But do not have performance issue.
$g_enable_email_notification = OFF;
$g_email_send_using_cronjob = ON;

Could you please suggest on this. Thanks