Re: installation for large volume

Hi Paul,

a) Please find the file attached for the stats output.

b) We are an ASP and each domain is one project.
    The project is related to mostly 3 people
    1. Consultant (manager access for the project)
    2. Webmaster (developer access for the project)
    3. Client (reporter access for the project)
    There are no sub projects but there might be project specific categories
in addition to the global categories.

c) I have not made any modification to the code but I have seen that the
list makes a cache of each project, so that might be the reason for so much
memory usage.
   At the moment it is a non issue as each consultant/webmaster may have
only 10s or a couple of hundred projects.

d) I have scripted to feed the data to the mantis database.
   1. get a list of all active domains and create a private project
(view_state=50)
   2. Get a list of consultant, webmaster, owner and create an account with
viewer access
   3. give the rights according to their role.


I dont know if it will be any worthy to make these modifications for this
specific need. I assume that this project was not designed to manage this
large volume of projects/users.
Basically I dont need much admin account functionality except just for
reporting purposes. We might anyway have to create our own reporting scripts
to customize them.

In anycase, let me know if I can help in anyway. We have been using this
software since 6 years and it is very useful.
best regards


On Fri, Apr 17, 2009 at 7:34 PM, Paul Richards <paul-P/[email protected]> wrote:

> Atif,
>
> We've done a fair amount of optimising since the a3 release (only in git
> trunk atm) to try to improve performance in some areas
>
> Would you mind:
> a) can you paste the output of /admin/db_stats.php
> b) in addition, whats your rough project structure: i.e. are there a lot of
> nest subprojects in use etc?
> c) do you currently make any changes to the code to reduce the size of the
> projects box at top right - or is that a non-issue as most people can only
> see 2-3 projects
> d) is your tests on live data, or have you generated a script to generate
> the database data currently?
>
> Paul
>
> ----- Original Message -----
> From: "Atif Ghaffar" <[email protected]>
> To: [email protected]
> Sent: Friday, April 17, 2009 12:49:30 AM GMT +00:00 GMT Britain, Ireland,
> Portugal
> Subject: [mantisbt-help] installation for large volume
>
> Hi all,
>
> We have been using mantis for a few years now and are very happy with.
> We want now to give our customers the possibility to use it too to manage
> their projects. With my quick tests I see some problems.
>
> Problem: Too much memory usage, too long to load the pages, etc
> *Fatal error*: Maximum execution time of 30 seconds exceeded in *
> /var/www/mantisbt-1.2.0a3/core/helper_api.php* on line
> *300, etc
>
> Note: This happens when loggin in as administrator who has the right to see
> all accounts and projects.
>
> *Details: (version 1.2.0a3)
> I have loaded around 30K projects and 20K users.
>
> We expect this to grow 10 times more very soon.
>
> Has anyone worked with a large install like this.
>
>
>
>
>
> --
> best regards
> Atif Ghaffar
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and around Java
> (TM) technology - register by April 22, and save $200 on the JavaOne (SM)
> conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on
> sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________ mantisbt-help mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> mantisbt-help mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help
>
>


-- 
best regards
Atif Ghaffar

------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p

_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help

<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"><title>Mantis Database Statistics</title></head><body><h1>Mantis Database Statistics</h1>mantis_bug_file_table = 1 records<br>mantis_bug_history_table = 8 records<br>mantis_bug_monitor_table = 0 records<br>mantis_bug_relationship_table = 0 records<br>mantis_bug_table = 3 records<br>mantis_bug_tag_table = 0 records<br>mantis_bug_text_table = 3 records<br>mantis_bugnote_table = 0 records<br>mantis_bugnote_text_table = 0 records<br>mantis_category_table = 3 records<br>mantis_news_table = 0 records<br>mantis_plugin_table = 1 records<br>mantis_project_file_table = 0 records<br>mantis_project_table = 2001 records<br>mantis_project_user_list_table = 3778 records<br>mantis_project_version_table = 0 records<br>mantis_tag_table = 0 records<br>mantis_user_table = 1479 records<br>mantis_user_profile_table = 0 records<br>mantis_user_pref_table = 4 records<br>mantis_user_print_pref_table = 0 records<br>mantis_custom_field_project_table = 0 records<br>mantis_custom_field_table = 1 records<br>mantis_custom_field_string_table = 0 records<br>mantis_filters_table = 0 records<br>mantis_sponsorship_table = 0 records<br>mantis_tokens_table = 5 records<br>mantis_project_hierarchy_table = 0 records<br>mantis_config_table = 1 records<br>mantis_email_table = 3 records<br></body></html>