From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id v4AfD+svmF/jEAAA0tVLHw (envelope-from ) for ; Tue, 27 Oct 2020 14:34: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 mp0 with LMTPS id 4N2MCusvmF8LHgAA1q6Kng (envelope-from ) for ; Tue, 27 Oct 2020 14:34: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 723B29402A2 for ; Tue, 27 Oct 2020 14:34:18 +0000 (UTC) Received: from localhost ([::1]:36276 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kXQ3D-0004Vp-Qt for larch@yhetil.org; Tue, 27 Oct 2020 10:34:15 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40528) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kXPgk-00027Y-R3 for bug-guix@gnu.org; Tue, 27 Oct 2020 10:11:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:33803) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kXPgk-0006lx-D8 for bug-guix@gnu.org; Tue, 27 Oct 2020 10:11:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kXPgk-0003dC-6M for bug-guix@gnu.org; Tue, 27 Oct 2020 10:11:02 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#43850: cuirass: inconsistent SQL queries execution time. Resent-From: Mathieu Othacehe Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 27 Oct 2020 14:11:02 +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: Christopher Baines Received: via spool by 43850-submit@debbugs.gnu.org id=B43850.160380781313890 (code B ref 43850); Tue, 27 Oct 2020 14:11:02 +0000 Received: (at 43850) by debbugs.gnu.org; 27 Oct 2020 14:10:13 +0000 Received: from localhost ([127.0.0.1]:45349 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kXPfx-0003by-HU for submit@debbugs.gnu.org; Tue, 27 Oct 2020 10:10:13 -0400 Received: from eggs.gnu.org ([209.51.188.92]:40110) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kXPfw-0003bj-LA for 43850@debbugs.gnu.org; Tue, 27 Oct 2020 10:10:12 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:51246) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kXPfq-0006VA-C3; Tue, 27 Oct 2020 10:10:06 -0400 Received: from [2a01:e0a:19b:d9a0:50c1:4a69:300e:4531] (port=38332 helo=cervin) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1kXPfp-0000H3-96; Tue, 27 Oct 2020 10:10:05 -0400 From: Mathieu Othacehe References: <87a6wyhviz.fsf@gnu.org> <87362gg35r.fsf@gnu.org> <87362986k7.fsf@gnu.org> <87blguzdig.fsf@gnu.org> <87blgo8ufs.fsf@gnu.org> <87d014yq3t.fsf@cbaines.net> Date: Tue, 27 Oct 2020 15:10:03 +0100 In-Reply-To: <87d014yq3t.fsf@cbaines.net> (Christopher Baines's message of "Tue, 27 Oct 2020 09:28:54 +0000") Message-ID: <871rhjyd38.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -3.3 (---) 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=pass (policy=none) header.from=gnu.org; 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: -1.51 X-TUID: VCJH24ux9Qxc Hello Chris, > I think Ricardo mentioned that the machine running Cuirass uses an SSD > for the root filesystem, so moving the database there may help? Looks like the database was already on the SSD before my tmpfs experiment. --8<---------------cut here---------------start------------->8--- mathieu@berlin ~$ df -h Filesystem Size Used Avail Use% Mounted on none 95G 0 95G 0% /dev /dev/sda1 916G 321G 549G 37% / /dev/sdb1 37T 34T 2.6T 94% /gnu tmpfs 95G 8.0K 95G 1% /dev/shm tmpfs 10G 2.4G 7.7G 24% /var/lib/cuirass_tmpfs --8<---------------cut here---------------end--------------->8--- I don't really get why I/O pressure on /dev/sdb could impact /dev/sda. Thanks, Mathieu