[aur-dev] [PATCH] Fix performance issues with new PackageDepends lookups

[Lukas Fleischer]

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 <dan at archlinux.org>
> > ---
> > 
> > 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...