MySQL user's Conference

Bradley Baetz bbaetz at
Fri Apr 18 23:48:25 UTC 2003

On Fri, Apr 18, 2003 at 11:47:34AM -0700, Myk Melez wrote:
> Bradley Baetz wrote:
> >I have this vague recollection that its [bmo] a 4G machine, but I'm not
> >too sure.
> > 
> >
> That's right.  I did some tuning at one point based on the "huge" 
> example, but it didn't seem to do much good.

Yeah, I suspect we're just too CPU bound. It is apache taking most of
the time, right?

FWIW, I have mod_perl working locally now for show_bug, with a
combination of patches. After my patches go in, I'll tidy my
patchset up (and remove some of the more disgusting hacks), and then we
can try it on bmo.... mod_perl/1.0 now, mind you, but still.

> Except that we do look at it a lot for request queue queries.

Those are slow because it uses the 'old' way of detecting bug
visibility. Theres a bug on speeding that up, FWIW.

Theres another bug on just making the queue a buglist.cgi format, too,
but that requires a bit of backedn work to get teh roght data out, and
would be a lot easier with subselects (ie "SELECT <request data> from
attachments, requests WHERE attachments.bug_id IN (" . $search->getSQL()
. ") AND ...")

> -myk


More information about the developers mailing list