Hi
I have setup Mantis (v1.08 stable) on a dedicated server. The server statistics are of my concern as they seem to be very high.
Memory Usage
-----------------
Total = 993.47 MB
Used = 861.89 MB
Free = 131.58 MB
Shared = 0 B
Buffer = 59.98 MB
Cached = 561.84 MB
Usage = 30.2%
This is the usage since the server was hosted about 1 day back.
The OS is Linux 2.6.9-55.0.6 CentOS.
CPU: GenuineIntel, Intel(R) Pentium(R) 4 CPU 3.00GHz
The database statistics are as follows:
mantis_bug_file_table = 7182 records
mantis_bug_history_table = 84999 records
mantis_bug_monitor_table = 18 records
mantis_bug_relationship_table = 56 records
mantis_bug_table = 2499 records
mantis_bug_text_table = 7287 records
mantis_bugnote_table = 10418 records
mantis_bugnote_text_table = 10418 records
mantis_config_table = 52 records
mantis_custom_field_project_table = 0 records
mantis_custom_field_string_table = 0 records
mantis_custom_field_table = 0 records
mantis_filters_table = 901 records
mantis_news_table = 0 records
mantis_project_category_table = 703 records
mantis_project_file_table = 0 records
mantis_project_hierarchy_table = 0 records
mantis_project_table = 31 records
mantis_project_user_list_table = 467 records
mantis_project_version_table = 0 records
mantis_sponsorship_table = 0 records
mantis_tokens_table = 1 records
mantis_upgrade_table = 325 records
mantis_user_pref_table = 49 records
mantis_user_print_pref_table = 10 records
mantis_user_profile_table = 0 records
mantis_user_table = 49 records
As you can see the data is not as high as some other installations. I routinely optimize the tables, repair and keep them tuned. I have kept the file uploads on the DISK (not DATABASE). Also I have turned off Bug History display on bugs view to keep the query count low.
We had these issues and had been nearly labeled as abusive by our shared web host. Thats the reason we switched to dedicated hosting. And looks like the issues have trailed us. The CPU usage touches all time high when there are about 30-40 users. It would be interesting to know what kind of optimizations are required to keep Mantis working smoothly.
Thanks
R
Deteriorating Mantis Performance
Moderators: Developer, Contributor
Sorry, posted in wrong forum
Hi Moderator,
I posted this in general discussion instead of HELP. Can you move it to the appropriate forum please?
I am looking upto the users and mantis-gurus where I went wrong with my mantis setup.
thanks
R
I posted this in general discussion instead of HELP. Can you move it to the appropriate forum please?
I am looking upto the users and mantis-gurus where I went wrong with my mantis setup.
thanks
R
Is there a solution to this?
Hi,
Can anyone please let me know if this is a known issue? I am experiencing the same issue across three installations. the common factors in all three are: the mantis version and the database.
In my previous post, I had posted the information of one installation which had the least data. Theres another one with about 1,25,000 records. Its also having the same problem.
cheers
R
Can anyone please let me know if this is a known issue? I am experiencing the same issue across three installations. the common factors in all three are: the mantis version and the database.
In my previous post, I had posted the information of one installation which had the least data. Theres another one with about 1,25,000 records. Its also having the same problem.
cheers
R
Re: Deteriorating Mantis Performance
Hi,
which DB do you use? I use MSSQL but I have read that you have to create some index on your table... on MSSQL everything works great! (About 35000 tickets)
which DB do you use? I use MSSQL but I have read that you have to create some index on your table... on MSSQL everything works great! (About 35000 tickets)
sabkaraja wrote:Hi
I have setup Mantis (v1.08 stable) on a dedicated server. The server statistics are of my concern as they seem to be very high.
Memory Usage
-----------------
Total = 993.47 MB
Used = 861.89 MB
Free = 131.58 MB
Shared = 0 B
Buffer = 59.98 MB
Cached = 561.84 MB
Usage = 30.2%
This is the usage since the server was hosted about 1 day back.
The OS is Linux 2.6.9-55.0.6 CentOS.
CPU: GenuineIntel, Intel(R) Pentium(R) 4 CPU 3.00GHz
The database statistics are as follows:
mantis_bug_file_table = 7182 records
mantis_bug_history_table = 84999 records
mantis_bug_monitor_table = 18 records
mantis_bug_relationship_table = 56 records
mantis_bug_table = 2499 records
mantis_bug_text_table = 7287 records
mantis_bugnote_table = 10418 records
mantis_bugnote_text_table = 10418 records
mantis_config_table = 52 records
mantis_custom_field_project_table = 0 records
mantis_custom_field_string_table = 0 records
mantis_custom_field_table = 0 records
mantis_filters_table = 901 records
mantis_news_table = 0 records
mantis_project_category_table = 703 records
mantis_project_file_table = 0 records
mantis_project_hierarchy_table = 0 records
mantis_project_table = 31 records
mantis_project_user_list_table = 467 records
mantis_project_version_table = 0 records
mantis_sponsorship_table = 0 records
mantis_tokens_table = 1 records
mantis_upgrade_table = 325 records
mantis_user_pref_table = 49 records
mantis_user_print_pref_table = 10 records
mantis_user_profile_table = 0 records
mantis_user_table = 49 records
As you can see the data is not as high as some other installations. I routinely optimize the tables, repair and keep them tuned. I have kept the file uploads on the DISK (not DATABASE). Also I have turned off Bug History display on bugs view to keep the query count low.
We had these issues and had been nearly labeled as abusive by our shared web host. Thats the reason we switched to dedicated hosting. And looks like the issues have trailed us. The CPU usage touches all time high when there are about 30-40 users. It would be interesting to know what kind of optimizations are required to keep Mantis working smoothly.
Thanks
R
sabkaraja, can you try the patch suggested in the following patch and let me know if it makes things better:
http://www.mantisbt.org/bugs/view.php?id=7516
http://www.mantisbt.org/bugs/view.php?id=7516
Migrate your MantisBT to the MantisHub Cloud
Hi vboctor,
I tried to patch the file but I am getting this error:
Am I patching a wrong version of filter_api.php ? The filter_api.php version which I am patching shows:
filter_api.php,v 1.122.2.2.2.3.2.5.2.3.2.1 2006/05/06 03:01:07 vboctor Exp $
I tried to patch manually, but found that code blocks mentioned in the patch are missing the version of file I have. Is the patch for a 1.1.x (not 1.0.8)?
cheers
R
I tried to patch the file but I am getting this error:
Code: Select all
$ patch filter_api.php < optimizepatch.patch
(Stripping trailing CRs from patch.)
patching file filter_api.php
Hunk #1 succeeded at 721 (offset -524 lines).
Hunk #2 FAILED at 741.
Hunk #3 FAILED at 749.
Hunk #4 FAILED at 886.
3 out of 4 hunks FAILED -- saving rejects to file filter_api.php.rej
filter_api.php,v 1.122.2.2.2.3.2.5.2.3.2.1 2006/05/06 03:01:07 vboctor Exp $
I tried to patch manually, but found that code blocks mentioned in the patch are missing the version of file I have. Is the patch for a 1.1.x (not 1.0.8)?
cheers
R
The bug is reported against 1.1.0a1 and the patch is likely to be against the 1.1.x branch. Hopefully we will get this into 1.1.0rc1 which will be released in the next week.
Migrate your MantisBT to the MantisHub Cloud
Mantis 1.1.0rc2 will be released in the next couple of days. I think we are very close to 1.1.0, so maybe first week of November.
Migrate your MantisBT to the MantisHub Cloud