MySQL user's Conference

[Bradley Baetz]

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 User.pm 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

Bradley