Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9B65D945B for ; Thu, 22 Dec 2011 21:01:42 +0000 (UTC) Received: (qmail 83619 invoked by uid 500); 22 Dec 2011 21:01:40 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 83472 invoked by uid 500); 22 Dec 2011 21:01:40 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 83464 invoked by uid 99); 22 Dec 2011 21:01:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Dec 2011 21:01:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of chrisstocktonaz@gmail.com designates 209.85.210.180 as permitted sender) Received: from [209.85.210.180] (HELO mail-iy0-f180.google.com) (209.85.210.180) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Dec 2011 21:01:32 +0000 Received: by iazz13 with SMTP id z13so15374753iaz.11 for ; Thu, 22 Dec 2011 13:01:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=TsQNiSmM2sjtcbyXdDdK874kqilTHi4+kiQRcVRgxK8=; b=Wx7l+os0gsCdZQcec8WSBTpsYNMYYt/kadkZSnC3uADeaFx6amYRyGzs4zP3P2xN9z QfyWhnLZwtEediU4RPzgS0L9xm8Izgymy5bTCtbOiXAQVR76lJb2heaTC3/GQORjbw1J capUZOk68pZPveZ0m9zyk9wfwSBJHDWvHULWA= MIME-Version: 1.0 Received: by 10.42.148.4 with SMTP id p4mr2836044icv.9.1324587671109; Thu, 22 Dec 2011 13:01:11 -0800 (PST) Received: by 10.42.197.72 with HTTP; Thu, 22 Dec 2011 13:01:11 -0800 (PST) Date: Thu, 22 Dec 2011 14:01:11 -0700 Message-ID: Subject: Database size seems off even after compaction runs. From: Chris Stockton To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org We have a customer using 11MB of disk space, not much but it so happens the user is using more like 100KB of data. One thing we have noticed is that the users doc_del_count is very high, indicating he likely had 11mb of data but later deleted it. {"db_name":"...snip...","doc_count":49,"doc_del_count":42981,"update_seq":86097,"purge_seq":0,"compact_running":false,"disk_size":11427940,"instance_start_time":"1324102884349705","disk_format_version":5,"committed_update_seq":86097} After compaction the size does not change, the physical file on the file system is verified 11MB. Viewing _all_docs shows a page and a half of data, viewing futon shows the user really is using around 100kb max. Any guesses here? -Chris