Date: Wed, 21 May 2008 19:33:56 +0200 From: Tomasz Pajor <nikon@kei.pl> To: <freebsd-performance@freebsd.org> Subject: Re: mysql performance on freebsd 7 Message-ID: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> In-Reply-To: <20080521192843.30ca3833@mort.in.publishing.hu> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?257034819c08b52542969ccbf90207fc.nikon>