we have been using mantis in our organization from last couple of years and slowly over time data has grown up , almost 12000k bugs/entries have been entered and sql has a data size of 14GB so when ever we add note or click other pages or search for bugs/tracking id it takes a lot of time to pull details, pls suggest if any other way to make little faster/quicker.
Thank u
mantis had become slow
Moderators: Developer, Contributor
Re: mantis had become slow
You mean 12,000,000?
It's hard to tell anything without some more information, e.g.
- What means "long", 1 second, 5 seconds ...?
- When started it to become slow ?
- What's the output of http://<yourMantisURL>/admin/db_stats.php ?
- used hardware, CPU, disks, memory
- Exact version of MantisBT, PHP, Database, Web server, Browser and Operating System
- Relevant customizations (e.g. changes in config_inc.php, etc)
- Installed plugins or custom functions ?
- Was the MantisBT source code modified in any way ?
Re: mantis had become slow
Hi Atrol,
I thank you for your kind help and support that you always provide so far from germany...
you mean 12,000,000?
Ans. no it just 12,000 bug/tracking/entries.
It's hard to tell anything without some more information, e.g.
Ans. yes i don undertand
- What means "long", 1 second, 5 seconds ...?
Ans. Yes it more then 10-15 seconds while clicking in any page. eg. summary or back. also it takes 2-3 minutes for searching any data.
- When started it to become slow ?
Ans. no it was working super since data was not much that time.
- What's the output of http://<yourMantisURL>/admin/db_stats.php ?
Ans.http://server:81/mantis/admin/db_stats.php
Not Found
The requested URL /mantis/admin.tar.gz/db_stats.php was not found on this server.
- used hardware, CPU, disks, memory
Ans. Intel Xeon CPU 2.13 Ghz, 6GB RAM, 500GB HDD.
- Exact version of MantisBT, PHP, Database, Web server, Browser and Operating System
Ans. mantis-1.2.19-0, have used bitnami mantis, firefox/chrome/ windows server 2003
- Relevant customizations (e.g. changes in config_inc.php, etc)
Ans. no nothing.
- Installed plugins or custom functions ?
Ans. No
- Was the MantisBT source code modified in any way ?
Ans.No, but some customs fields have been added as per own use.
Thanks & Regards
Hussain
India
I thank you for your kind help and support that you always provide so far from germany...
you mean 12,000,000?
Ans. no it just 12,000 bug/tracking/entries.
It's hard to tell anything without some more information, e.g.
Ans. yes i don undertand
- What means "long", 1 second, 5 seconds ...?
Ans. Yes it more then 10-15 seconds while clicking in any page. eg. summary or back. also it takes 2-3 minutes for searching any data.
- When started it to become slow ?
Ans. no it was working super since data was not much that time.
- What's the output of http://<yourMantisURL>/admin/db_stats.php ?
Ans.http://server:81/mantis/admin/db_stats.php
Not Found
The requested URL /mantis/admin.tar.gz/db_stats.php was not found on this server.
- used hardware, CPU, disks, memory
Ans. Intel Xeon CPU 2.13 Ghz, 6GB RAM, 500GB HDD.
- Exact version of MantisBT, PHP, Database, Web server, Browser and Operating System
Ans. mantis-1.2.19-0, have used bitnami mantis, firefox/chrome/ windows server 2003
- Relevant customizations (e.g. changes in config_inc.php, etc)
Ans. no nothing.
- Installed plugins or custom functions ?
Ans. No
- Was the MantisBT source code modified in any way ?
Ans.No, but some customs fields have been added as per own use.
Thanks & Regards
Hussain
India
Re: mantis had become slow
12000 issues should be no problem, e.g. there are more than 16000 at www.mantisbt.org/bugs
admin.tar.gz? tar.gz? I didn't tell anything about tar.gzhussain92 wrote: ↑05 Nov 2018, 05:52 - What's the output of http://<yourMantisURL>/admin/db_stats.php ?
Ans.http://server:81/mantis/admin/db_stats.php
Not Found
The requested URL /mantis/admin.tar.gz/db_stats.php was not found on this server.
Independant from that, the admin folder might have been removed.
You could restore it from this download https://sourceforge.net/projects/mantis ... le/1.2.19/
As a side note, keep in mind that Mantis-1.2.19 and Windows Server 2003 are complete outdated, full of known security issues and no longer supported.
As a first step I recommend to run optimize table on all tables of your Mantis database
https://dev.mysql.com/doc/refman/5.5/en ... table.html
Re: mantis had become slow
Thank you Atrol for the reply n help, surely i will follow as per ur instruction n soon will update u
Re: mantis had become slow
Also Mr. Atrol i would like to know how to update mantis from present version to latest in same production platform
Re: mantis had become slow
How to upgrade https://www.mantisbt.org/docs/master/en ... ll.upgrade
But keep in mind that there are some minimum requirements to run Mantis 2.x, e.g. PHP minimum version is 5.5.x, 7.x is recommended.
https://www.mantisbt.org/docs/master/en ... e.versions
But keep in mind that there are some minimum requirements to run Mantis 2.x, e.g. PHP minimum version is 5.5.x, 7.x is recommended.
https://www.mantisbt.org/docs/master/en ... e.versions
Re: mantis had become slow
thank you for the help, will work on it..
Re: mantis had become slow
how to upgrade from windows mantis version 2.17.0 to 2.18.0 in windows