From dev-return-48847-archive-asf-public=cust-asf.ponee.io@couchdb.apache.org Thu Oct 10 12:16:45 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 181F4180626 for ; Thu, 10 Oct 2019 14:16:45 +0200 (CEST) Received: (qmail 85414 invoked by uid 500); 10 Oct 2019 12:16:44 -0000 Mailing-List: contact dev-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@couchdb.apache.org Delivered-To: mailing list dev@couchdb.apache.org Received: (qmail 85402 invoked by uid 99); 10 Oct 2019 12:16:44 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Oct 2019 12:16:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 63074C2270 for ; Thu, 10 Oct 2019 12:16:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.274 X-Spam-Level: X-Spam-Status: No, score=0.274 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_LOW=-0.7, SPF_HELO_NONE=0.001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id NSVG_SRJ28nv for ; Thu, 10 Oct 2019 12:16:41 +0000 (UTC) Received-SPF: Softfail (mailfrom) identity=mailfrom; client-ip=95.143.172.184; helo=monoceres.uberspace.de; envelope-from=jan@apache.org; receiver= Received: from monoceres.uberspace.de (monoceres.uberspace.de [95.143.172.184]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 2A15FBCB40 for ; Thu, 10 Oct 2019 12:09:47 +0000 (UTC) Received: (qmail 7535 invoked from network); 10 Oct 2019 12:09:40 -0000 Received: from localhost (HELO ?IPv6:2a02:8106:1d:4a00:a4b7:677d:1e1e:9f9b?) (127.0.0.1) by monoceres.uberspace.de with SMTP; 10 Oct 2019 12:09:40 -0000 From: Jan Lehnardt Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\)) Subject: Re: CouchDB and future Date: Thu, 10 Oct 2019 14:09:38 +0200 References: <23525b22-b5c4-61c4-5e0f-da628aa1d2c4@rebhu.com> <7867734d-0404-6bb9-829d-ccf0ecdf175c@rebhu.com> <75714e71-1daf-aed4-3e72-9c5b1461e08d@rebhu.com> <1f03ccd9-1e79-5594-352c-a698dc2bdb61@rebhu.com> <29bd5e87-ff8a-9aae-515b-8aa479ee778e@rebhu.com> <33085D81-CE2B-4C0E-A456-0DB77EF55FBA@apache.org> <24b570fa-17b4-c96b-c4e6-629e6a4c5143@apache.org> <33c315ab-1e9e-ac9a-a3f9-741f1f5c066d@apache.org> To: CouchDB Developers In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3445.104.11) Hi ermouth, thanks for providing these. Do you have a feeling for a scenario with = q>1 on a single-core. single-thread system? Best Jan =E2=80=94 > On 4. Oct 2019, at 23:40, ermouth wrote: >=20 > This tuned out to be interesting, results vary heavily for different > platforms. >=20 > I included `perftest.html` into Photon design doc. The utility gives = good > insight how q,n impact doc creation, doc update, validate + update, = and > viewindex create/update =E2=80=93 for a particular CouchDB instance. >=20 > Common observations: > * q=3D1 is only ok for rare special cases (like DBs with dozen docs) > * it=E2=80=99s ok to have q=3D=3Dcores or q=3D=3Dcores+1 or even = cores+2: write perf drops > a little, but viewindex update is bit faster > * excessive q (say, more than cores=C3=972) negatively impacts direct = write > perf: having q8 for 2core at least halves write perf for most > commodity/lean platforms and hw cfg. >=20 > ermouth >=20 >=20 > =D1=87=D1=82, 11 =D0=B8=D1=8E=D0=BB. 2019 =D0=B3. =D0=B2 18:17, Joan = Touzet : >=20 >> On 2019-07-11 8:05, ermouth wrote: >>>> to help with the documentation step >>>=20 >>> Probably. Please give me a hint what you need. >>=20 >> What default settings right now are wrong for a system with low RAM, = low >> CPU, and slow disk - such as a RaspberryPi v1, or a $15/mo AWS = server? >>=20 >> -Joan >>=20 >>=20 --=20 Professional Support for Apache CouchDB: https://neighbourhood.ie/couchdb-support/