From owner-freebsd-performance@FreeBSD.ORG Wed May 21 18:41:14 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 352A7106566B for ; Wed, 21 May 2008 18:41:14 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id DE88E8FC19 for ; Wed, 21 May 2008 18:41:13 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from pool-0461.adsl.interware.hu ([213.178.101.205] helo=mort.in.publishing.hu) by marvin.harmless.hu with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1JytFQ-0001YX-QE; Wed, 21 May 2008 20:41:12 +0200 Date: Wed, 21 May 2008 20:41:09 +0200 From: CZUCZY Gergely To: Tomasz Pajor Message-ID: <20080521204109.3c9e601d@mort.in.publishing.hu> In-Reply-To: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> 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> <257034819c08b52542969ccbf90207fc.nikon@kei.pl> Organization: Harmless Digital Bt X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.1; i386-portbld-freebsd6.3) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/LOU3Dci9Ysd2w.jSnmKkyHa"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Sender: Czuczy Gergely Cc: freebsd-performance@freebsd.org 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 18:41:14 -0000 --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable ahh, sorry. missunderstood that. i've seen many places they've put the data into memory disks. i've thought that's being done here also. On Wed, 21 May 2008 19:33:56 +0200 Tomasz Pajor wrote: > > > How the filesystem is relevant when tables are in memory? =20 > > first, they 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 =20 >=20 > http://dev.mysql.com/doc/refman/5.1/en/memory-storage-engine.html >=20 > "As indicated by the name, MEMORY tables are stored in memory. They > use hash indexes by default, which makes them very fast, and very > useful for creating temporary tables. However, when the server shuts > down, all rows stored in MEMORY tables are lost. The tables > themselves continue to exist because their definitions are stored > in .frm files on disk, but they are empty when the server restarts." >=20 > so only the structure is in file not data --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINGzHzrC0WyuMkpsRAnvlAJ4oYq4nozf1y6rrphr4r+dvll293QCeNTS2 dY2tsbpTGouuU3ssGg8OVMU= =15Bd -----END PGP SIGNATURE----- --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa--