Date: Wed, 21 May 2008 20:41:09 +0200 From: CZUCZY Gergely <gergely.czuczy@harmless.hu> To: Tomasz Pajor <nikon@kei.pl> Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 Message-ID: <20080521204109.3c9e601d@mort.in.publishing.hu> In-Reply-To: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> References: <be8c1fa47808266f0e520175c6bbbf1e.t.pajor@kei.pl> <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>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] 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 <nikon@kei.pl> wrote: > > > How the filesystem is relevant when tables are in memory? > > 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 > > http://dev.mysql.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 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." > > so only the structure is in file not data -- Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINGzHzrC0WyuMkpsRAnvlAJ4oYq4nozf1y6rrphr4r+dvll293QCeNTS2 dY2tsbpTGouuU3ssGg8OVMU= =15Bd -----END PGP SIGNATURE-----home | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080521204109.3c9e601d>