From owner-freebsd-questions@FreeBSD.ORG Mon Apr 11 01:25:57 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id ACCE316A4CE for ; Mon, 11 Apr 2005 01:25:57 +0000 (GMT) Received: from proxy.ddcom.co.jp (proxy.ddcom.co.jp [211.121.191.163]) by mx1.FreeBSD.org (Postfix) with SMTP id 84D9C43D54 for ; Mon, 11 Apr 2005 01:25:56 +0000 (GMT) (envelope-from rees@ddcom.co.jp) Received: (qmail 27703 invoked by alias); 11 Apr 2005 01:38:18 -0000 Received: from unknown (HELO matthew) (10.10.10.11) by mail.ddcom.local with SMTP; 11 Apr 2005 01:38:18 -0000 Date: Mon, 11 Apr 2005 10:25:55 +0900 From: Joel To: freebsd-questions@freebsd.org In-Reply-To: <20050411000641.GB620@Pandora.MHoerich.de> References: <20050409223001.GA58918@kirk.dlee.org> <20050411000641.GB620@Pandora.MHoerich.de> Message-Id: <20050411102005.6047.REES@ddcom.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-2022-JP" Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver. 2.00.06 Subject: Re: Anyone ever consider a filesystem served by MySQL for mail folders? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 11 Apr 2005 01:25:57 -0000 > > > The disadvantage is that you need to provide around 4 times as much disk > > > space for a DB-based mailstore as you would for a normal mbox/maildir style > > > representation, you need to provide a lot more server horsepower, you need > > > to continuously maintain and purge old mail from the database, and you end > > > up with your mail buried in database tables, so heaven help you if the > > > database becomes inconsistent and you need to recover. > > Whereas you can repair mbox-files with your favorite editor > and employ pretty much the same level of fancy searching > with a couple of scripts. I am not recommending a database to resolve this problem, but I'll note here that a text editor for searching has its limits when the bulk of the mail is Japanese (or any other predominantly non-Latin language). Speaking of which, anyone know of an editor/filter combination that can handle all the funny encodings used to make mail 7-bit safe? (Base 64 excepted, of course.) -- Joel Rees digitcom, inc. 株式会社デジコム Kobe, Japan +81-78-672-8800 ** **