On Tue, Apr 12, 2011 at 4:36 AM, Lukas Fleischer <archlinux@cryptocrack.de> wrote:
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@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...
I wouldn't worry about it unless you really want to spend time preparing a release- if you know one site running the AUR code that is at even 10% of the capacity of the main site, I'd be surprised. And they should be following this list anyway, and could apply the index at any time. :) -Dan