Mantis Bug Tracker - Forums

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

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

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

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)

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

I use MYSQL. My database is indexed.
I checked and even went far to recreate the indexes. I did that by running the admin/upgrade. And copying the sql queries. Then I took all the index queries and ran them on the database.

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

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

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.

Hi

When is 1.1.x expected to be released ?

Didnt see anything related to this on the roadmap

cheers
R

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.