From owner-freebsd-performance@FreeBSD.ORG Wed May 21 17:33:59 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1A310106564A for ; Wed, 21 May 2008 17:33:59 +0000 (UTC) (envelope-from nikon@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 4F3D58FC19 for ; Wed, 21 May 2008 17:33:57 +0000 (UTC) (envelope-from nikon@kei.pl) Received: (qmail 23232 invoked by uid 45007); 21 May 2008 17:33:56 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 17:33:56 -0000 References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu><3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl><20080521182530.23c8f787@mort.in.publishing.hu><78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> <20080521192843.30ca3833@mort.in.publishing.hu> In-Reply-To: <20080521192843.30ca3833@mort.in.publishing.hu> Received: from 77.236.13.109 (Poczta WWW Kei.pl authenticated user nikon@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 19:33:56 +0200 (CEST) Message-ID: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> From: Tomasz Pajor To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 19:33:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 77.236.13.109 X-Http-User-Agent: Opera/9.50 (Windows NT 6.0; U; pl) Subject: Re: mysql performance on freebsd 7 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2008 17:33:59 -0000 > > How the filesystem is relevant when tables are in memory? > first, the= y somehow have to be put into the memory > second, for consistency (yeah, = this word is missing from toysql-users' > vocabulary) it has to write the = data to the disk. otherwise you'd lose > anything on a crash http://dev= =2Emysql.com/doc/refman/5.1/en/memory-storage-engine.html "As indicated = by the name, MEMORY tables are stored in memory. They use hash indexes by d= efault, which makes them very fast, and very useful for creating temporary = tables. However, when the server shuts down, all rows stored in MEMORY tabl= es are lost. The tables themselves continue to exist because their definiti= ons are stored in .frm files on disk, but they are empty when the server re= starts." so only the structure is in file not data