On Tue, Apr 12, 2011 at 11:23:38AM +0200, Lukas Fleischer wrote: > On Mon, Apr 11, 2011 at 08:03:43PM -0500, Dan McGee wrote: > > We do a lookup by DepName in the package details view, but I made the > > silly mistake of forgetting this index addition in the upgrade steps. > > > > Signed-off-by: Dan McGee <[email protected]> > > --- > > > > Lukas- said missing index was the cause of the increased CPU usage/load on > > sigurd, it appears. I already created this index in production as I was the > > one > > who forgot it in my last set of patches, whoops! > > How serious is this? I didn't check server load recently. If this one > really stresses the server, we should probably put this into another > maintainance release instead of 1.9.0 (although I'm not sure if anyone > will care).
Just had a look at the Munin stats for sigurd. Looks like the missing index makes CPU usage go up by an average of 30% which is quite much...
