mantis had become slow

[hussain92]

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

[atrol]

almost 12000k bugs/entries

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 ?

[hussain92]

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

[atrol]

you mean 12,000,000?
Ans. no it just 12,000 bug/tracking/entries.

12000 issues should be no problem, e.g. there are more than 16000 at www.mantisbt.org/bugs

- 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.

admin.tar.gz? tar.gz? I didn't tell anything about tar.gz
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/

- 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

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

[hussain92]

Thank you Atrol for the reply n help, surely i will follow as per ur instruction n soon will update u

[hussain92]

Also Mr. Atrol i would like to know how to update mantis from present version to latest in same production platform

[atrol]

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

[hussain92]

thank you for the help, will work on it..

[hussain92]

how to upgrade from windows mantis version 2.17.0 to 2.18.0 in windows

[atrol]

https://www.mantisbt.org/docs/master/en ... ll.upgrade