0010317: I just used mantis1.1.6, I found if update issue, will need 15sec, how can I improve it?

(0021459)
eunice (reporter)
2009-04-10 01:18

improve mantis or SQL

(0021463)
jreese (administrator)
2009-04-10 08:51

I'm thinking perhaps there might be latency issues with your server, either between the filesystem or the database. As you can see here, we have over ten thousand issues reported, and it stays very quick, and we only have it running on a virtual private server with 1GB available memory. I would double check with whoever is hosting your server to check that a) has a fast enough connection to the database and filesystem, b) is not "swapping" memory a lot, and c) is not hosting too many other projects. Those three factors can all contribute to a slow server; if your server uses NFS to retrieve the files that it's hosting, that can add a very large dela in rendering time.

(0021464)
eunice (reporter)
2009-04-10 10:24

Hi, Jreese, thank your answer.... ^_^
our physical server:
(1) windows 2003 server (2) 2G memory (3). I create XAMPP to setup Mantis
(4). The Server only run Mantis system

Client IE -> Connect server => local IP connect

So I don't know what's problem...
But I found : if update issue is : only write some words, it's about 5-7 sec, but if I update issue : change "custom defined field" item -> press update , it will have more time (about 15 sec)

Could you help to check it ?? Thank you...^_^

I want to use the mantis bugtracking to try your update issue time, but I cannot see update issue button....so...

(0021476)
thraxisp (manager)
2009-04-11 20:25

As a test, turn off email notifications. If the performance improves, the problem lies in your mail server. There is a provision to queue the emails and process them in the background.

(0021478)
eunice (reporter)
2009-04-12 21:45

Hi, Thraxisp:
    Yes, I turn off email notifications, the performance improve....
    New issue and update issue only 1-2 sec, it's very good...
    But we must have mail server to notified related member ~~
    I cannot manage mail server, so how to talk to MIS member about mail server?
    But I guess: maybe Mantis send mail to many people at one time ,so
    performance slow down.....maybe I can setup something (ex: modify mail
    content..) at mantis system...
    How about it?
    Any thank you veru much for your help...

(0021524)
giallu (developer)
2009-04-14 11:05

eunice, yes you can configure mantis to send mails in batches.

See:
http://www.mantisbt.org/wiki/doku.php/mantisbt:setting_up_mail_queuing [^]

for details

(0021572)
eunice (reporter)
2009-04-16 09:03

Hi, Giallu
    Thank your support good message...
    And I set email_send_using_cronjob configuration item to ON.
    But other descript : I cannot understand what's meaning....
    I see email_send_using_cronjob configuration : will wait 5 min to send??
    but I cannot received any mail?
    And ......
    How to set
    " Minute = *, Hour = *, Day = *, Month = *, Weekday = * "??
    Sorry, I am not professional engineer, so could you tell me detail...
    or every step....^Q^

    Could you help me ??

    Thank you very much....

(0021574)
giallu (developer)
2009-04-16 10:25

I actually can't, mainly becasue I don't use Windows. Since it does not look like a bug in our code, I suggest you bring this to the proper channel for support questions:

http://forums.mantisbt.org [^]

Thank you.

(0021645)
eunice (reporter)
2009-04-23 08:53

Thank for your help...
Now I manually set email_send_using_cronjob = ON in work Time every day
Then again email_send_using_cronjob = OFF in every morning, that will send mail~
(I will try to find how to set schedule..)
If I find, I will talk you again.

Again thank you very much....

Issue History
Date Modified	Username	Field	Change
2009-04-10 01:16	eunice	New Issue
2009-04-10 01:17	eunice	Issue Monitored: eunice
2009-04-10 01:18	eunice	Note Added: 0021459
2009-04-10 08:51	jreese	Note Added: 0021463
2009-04-10 08:51	jreese	Status	new => feedback
2009-04-10 10:24	eunice	Note Added: 0021464
2009-04-11 20:25	thraxisp	Note Added: 0021476
2009-04-12 21:45	eunice	Note Added: 0021478
2009-04-14 11:05	giallu	Note Added: 0021524
2009-04-16 09:03	eunice	Note Added: 0021572
2009-04-16 10:25	giallu	Note Added: 0021574
2009-04-16 10:25	giallu	Status	feedback => resolved
2009-04-16 10:25	giallu	Resolution	open => no change required
2009-04-16 10:25	giallu	Assigned To	=> giallu
2009-04-23 08:53	eunice	Note Added: 0021645
2009-06-26 12:00	vboctor	Status	resolved => closed

Notes
(0021459) eunice (reporter) 2009-04-10 01:18	improve mantis or SQL

(0021463) jreese (administrator) 2009-04-10 08:51	I'm thinking perhaps there might be latency issues with your server, either between the filesystem or the database. As you can see here, we have over ten thousand issues reported, and it stays very quick, and we only have it running on a virtual private server with 1GB available memory. I would double check with whoever is hosting your server to check that a) has a fast enough connection to the database and filesystem, b) is not "swapping" memory a lot, and c) is not hosting too many other projects. Those three factors can all contribute to a slow server; if your server uses NFS to retrieve the files that it's hosting, that can add a very large dela in rendering time.

(0021464) eunice (reporter) 2009-04-10 10:24	Hi, Jreese, thank your answer.... ^_^ our physical server: (1) windows 2003 server (2) 2G memory (3). I create XAMPP to setup Mantis (4). The Server only run Mantis system Client IE -> Connect server => local IP connect So I don't know what's problem... But I found : if update issue is : only write some words, it's about 5-7 sec, but if I update issue : change "custom defined field" item -> press update , it will have more time (about 15 sec) Could you help to check it ?? Thank you...^_^ I want to use the mantis bugtracking to try your update issue time, but I cannot see update issue button....so...

(0021476) thraxisp (manager) 2009-04-11 20:25	As a test, turn off email notifications. If the performance improves, the problem lies in your mail server. There is a provision to queue the emails and process them in the background.

(0021478) eunice (reporter) 2009-04-12 21:45	Hi, Thraxisp: Yes, I turn off email notifications, the performance improve.... New issue and update issue only 1-2 sec, it's very good... But we must have mail server to notified related member ~~ I cannot manage mail server, so how to talk to MIS member about mail server? But I guess: maybe Mantis send mail to many people at one time ,so performance slow down.....maybe I can setup something (ex: modify mail content..) at mantis system... How about it? Any thank you veru much for your help...

(0021524) giallu (developer) 2009-04-14 11:05	eunice, yes you can configure mantis to send mails in batches. See: http://www.mantisbt.org/wiki/doku.php/mantisbt:setting_up_mail_queuing [^] for details

(0021572) eunice (reporter) 2009-04-16 09:03	Hi, Giallu Thank your support good message... And I set email_send_using_cronjob configuration item to ON. But other descript : I cannot understand what's meaning.... I see email_send_using_cronjob configuration : will wait 5 min to send?? but I cannot received any mail? And ...... How to set " Minute = , Hour = , Day = , Month = , Weekday = * "?? Sorry, I am not professional engineer, so could you tell me detail... or every step....^Q^ Could you help me ?? Thank you very much....

(0021574) giallu (developer) 2009-04-16 10:25	I actually can't, mainly becasue I don't use Windows. Since it does not look like a bug in our code, I suggest you bring this to the proper channel for support questions: http://forums.mantisbt.org [^] Thank you.

(0021645) eunice (reporter) 2009-04-23 08:53	Thank for your help... Now I manually set email_send_using_cronjob = ON in work Time every day Then again email_send_using_cronjob = OFF in every morning, that will send mail~ (I will try to find how to set schedule..) If I find, I will talk you again. Again thank you very much....

Relationships