From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id cDV9FG/ol1/AWAAA0tVLHw (envelope-from ) for ; Tue, 27 Oct 2020 09:29:19 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id sLFHEG/ol18sfAAAB5/wlQ (envelope-from ) for ; Tue, 27 Oct 2020 09:29:19 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id D36929402A8 for ; Tue, 27 Oct 2020 09:29:18 +0000 (UTC) Received: from localhost ([::1]:56032 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kXLI5-0000YE-Dj for larch@yhetil.org; Tue, 27 Oct 2020 05:29:17 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:47248) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kXLHq-0000Xl-6H for bug-guix@gnu.org; Tue, 27 Oct 2020 05:29:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:59580) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kXLHp-0006NR-TP for bug-guix@gnu.org; Tue, 27 Oct 2020 05:29:01 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kXLHp-0006Rp-Q6 for bug-guix@gnu.org; Tue, 27 Oct 2020 05:29:01 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#43850: cuirass: inconsistent SQL queries execution time. Resent-From: Christopher Baines Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 27 Oct 2020 09:29:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 43850 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ludovic =?UTF-8?Q?Court=C3=A8s?= , Mathieu Othacehe Received: via spool by 43850-submit@debbugs.gnu.org id=B43850.160379094124782 (code B ref 43850); Tue, 27 Oct 2020 09:29:01 +0000 Received: (at 43850) by debbugs.gnu.org; 27 Oct 2020 09:29:01 +0000 Received: from localhost ([127.0.0.1]:42893 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kXLHp-0006Ra-33 for submit@debbugs.gnu.org; Tue, 27 Oct 2020 05:29:01 -0400 Received: from mira.cbaines.net ([212.71.252.8]:39958) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kXLHn-0006RS-3O for 43850@debbugs.gnu.org; Tue, 27 Oct 2020 05:28:59 -0400 Received: from localhost (92.41.179.191.threembb.co.uk [92.41.179.191]) by mira.cbaines.net (Postfix) with ESMTPSA id DBEDC27BBF2; Tue, 27 Oct 2020 09:28:57 +0000 (GMT) Received: from capella (localhost [127.0.0.1]) by localhost (OpenSMTPD) with ESMTP id 031037c7; Tue, 27 Oct 2020 09:28:55 +0000 (UTC) References: <87a6wyhviz.fsf@gnu.org> <87362gg35r.fsf@gnu.org> <87362986k7.fsf@gnu.org> <87blguzdig.fsf@gnu.org> <87blgo8ufs.fsf@gnu.org> User-agent: mu4e 1.4.13; emacs 27.1 From: Christopher Baines In-reply-to: <87blgo8ufs.fsf@gnu.org> Date: Tue, 27 Oct 2020 09:28:54 +0000 Message-ID: <87d014yq3t.fsf@cbaines.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: -0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -1.0 (-) X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: 43850@debbugs.gnu.org Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Spam-Score: -3.11 X-TUID: yRF9SKUpCyi6 --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Ludovic Court=C3=A8s writes: > Hi, > > Mathieu Othacehe skribis: > >>> I have now copied the database to a tmpfs mounted directory to make sure >>> that those inconsistent duration are only caused by the I/O pressure on >>> berlin. >> >> This helps a lot. The Cuirass web service has been running smooth since >> two days, without any inconsistent query times. > > Interesting. > >> I'm considering using a tmpfs backed database for good. The problem is >> that we would need a save/restore mechanism in case Berlin >> reboots. > > Hmm sounds risky, no? > > I wonder if we could instead ensure no I/O-intensive workload runs that > machine. I=E2=80=99m thinking in particular of the derivations that prod= uce > ISO/qcow images that are not offloaded but maybe should. > > WDYT? Do you think that=E2=80=99d be enough? Or is tmpfs our only hope? I think Ricardo mentioned that the machine running Cuirass uses an SSD for the root filesystem, so moving the database there may help? --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKlBAEBCgCPFiEEPonu50WOcg2XVOCyXiijOwuE9XcFAl+X6FZfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcRHG1haWxAY2Jh aW5lcy5uZXQACgkQXiijOwuE9XeKAA//W42HvAHLrMfMRdUSWjwc/r7CGqtznUtu FvRaNWC3wuZEF8G3PVxWg6+4Hql7FjoT1m5c79/EOKwiOM2vfPs4djKAHRwdWNZe xCevpKcuLuYV8lqergrmPUgZVaNYAZ1kZm9ysQHwnrreokuVaaRJMOJBkOglnlAG a9mNAHyWR+SXQdPgm0FGDWcaI6k6r9LsqYorKu3xxgwIP1kcPQFWn2b0WpHMMyUu o/VSNvZX+X/P2fpzH7yaPCpjV90iOwvPSbvF/OlwRemVGKt7wHvUdJu8Vyxb3L9y 6S2UXXAqnvOPs9X0yNnAQntYVkqPVu/Fz2kkSDFGIV6Y2xs82aGVGNSijvPf+AIx pRzzVx4XFyvCUMSLm7JHyxIwBAm/Tj/EVeOeIrKaZrCf3mAB2D9VjDej2oTcmcK2 h0p9mP4du6kNb6ee/qfFLB8dxD2z5kYjlUIPLk9thmDvNSfum7Lh29JJewiGul0Z gwN49Ghalc5Ch0otIm3bGBGucsDfCgrKtLUTYjWbOMqv0PZTcKvQj8X/m3yyqcbO pTK1PsbjfA9BVOdaXxDDxJvZH2Vl8gr4EjxI7Gq0bzgxV6C6I4xwKYh3YAP7hBsG PgRQ5LsBXYMWA50NesziZDTjr4A5TqGXfJDGsZdd4YqdJCgIlujDqQs/9QsOVeFh 9dvkk47YyIA= =54te -----END PGP SIGNATURE----- --=-=-=--