mysql performance + bugzilla

[Bruce Armstrong [TeamSybase]]

Try turning off the sendmailnow attribute.  In my experience most of the time there's a delay in the system it's not with Bugzilla updating the MySQL database, it's with Bugzilla waiting for the SMTP server to acknowledge the transmission of the emails.  If you turn that parameter off, the email generation is handled seperately from the bug update.

Jonathan Schatz <jon at vmware.com> wrote:I've gotten a few complaints here that our bugzilla is "too slow". most
of the complaints come from people who weren't around to witness the
horror of our old gnats installation, or the horror of bugzilla running
in a vm on my desktop. one of the complaints is that the bugs table will
continuously grow (and therefore become inefficient). i checked on b.m.o
and saw that there are > 200k bugs filed there (we're still under 40k
here). so my questions are:

1) does mysql performance degrade linearly with the size of a table?
2) is there any fancy reindexing i could do to speed up queries?
3) what hardware + software (specifically, db + httpd) is b.m.o running?

thanks,

-jon



-
To view or change your list settings, click here:



Bruce Armstrong [TeamSybase]

---------------------------------
http://www.teamsybase.com

Preach the gospel at all times.
If necessary, use words. -- Francis of Assisi
http://www.needhim.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20040112/f7ef30b3/attachment.html>