Mantis is slow
Moderators: Developer, Contributor
Mantis is slow
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
Could you please suggest for a fix
Thanks
Re: Mantis is slow
Thanks. This is taking 30 to 40 seconds to close an issue
Re: Mantis is slow
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
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
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
As a first step, you should answer my 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.
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
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
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
Attached the DB stats herewith
- Attachments
-
- MantisBT-DB-Statistics.png (183.81 KiB) Viewed 13130 times
Re: Mantis is slow
The questions
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?
is not meant that way.When did it start to be slow?
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
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
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
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.
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
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
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
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.
There is plenty of documentation around that process available.
Re: Mantis is slow
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
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
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
$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