DB Bottlenecks

[David Miller]

Maxwell Kanat-Alexander wrote:

> 	As I was writing the last email that I wrote, I realized that I don't
> really know where the bottlenecks would be in Bugzilla, with regard to
> DB performance.
> 
> 	Right now, it all pretty much seems to be perl performance that slows
> us down -- has anybody turned on slow_query logging in MySQL and picked
> out some common problems on large Bugzillas? Or done profiling of pages
> where it showed that significant time was being spent in the DB under
> certain situations?

Yeah, it was done once a while back... we have several bugs filed 
already on the subject (some have been fixed already - I know one had to 
do with the way the CC table was being joined when searching for bugs by 
email address from the query page)

It's been a couple years and the code's changed a lot though.  Probably 
wouldn't hurt to do it again.

I know next to zero of the load on bugzilla.mozilla.org is from the 
mysql server.  The majority of the CPU time wasted by Bugzilla is on 
initialization of the Template Toolkit.  That'll get solved when we get 
mod_perl working.

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/