mysql performance + bugzilla

[Myk Melez]

Jonathan Schatz wrote:

>1) does mysql performance degrade linearly with the size of a table?
>  
>
Depends on the type of query.  In general, queries doing full table 
scans should degrade linearly, while queries using indexes shouldn't 
degrade at all.

>2) is there any fancy reindexing i could do to speed up queries?
>  
>
Yes, there's lots of fancy (and not so fancy) indexing you can do to 
speed up queries.  Your first step is to figure out what's taking so 
long.  It might not be the queries themselves but rather the CGI script 
instantiation or, as another respondent pointed out, bug mail sending.

If it is the queries, the next step is to identify the queries that are 
taking too long.  Add &debug=1 to buglist.cgi URLs to see the query 
being run, then run "EXPLAIN <query>" in mysql to see what indexes MySQL 
thinks it should be using.  If those indexes are insufficient, add 
some.  If the appropriate indexes are there, but MySQL isn't using them, 
your database may be corrupt, or the query itself may be structured 
inefficiently.

In general, there's no reason to thow away Bugzilla for poor DB 
performance.  The database itself is fairly well designed, and almost 
all performance problems in it should be fixable bugs.

>3) what hardware + software (specifically, db + httpd) is b.m.o running?
>  
>
The hardware is a Compaq PowerEdge 1750 with two 2.4Ghz Intel Xeon 
hyperthreaded processors, 4GB memory, and some 10K RPM Ultra320 SCSI 
hard drives in a RAID 10 mirrored/striped configuration.  The software 
is MySQL 4.0.14 + Apache 1.3.27.  We're running other things besides 
Bugzilla on that server.

This thread really belongs in the newsgroup.  cc:ing it.

-myk