Date: Wed, 21 May 2008 19:28:43 +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: <20080521192843.30ca3833@mort.in.publishing.hu> In-Reply-To: <78f2745340c587cd4f000ffac8b3e85f.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>
next in thread | previous in thread | raw e-mail | index | archive | help
--Sig_/hpnHH.TjDehp0Y1Xj/gBITA Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 21 May 2008 19:03:55 +0200 Tomasz Pajor <nikon@kei.pl> wrote: > > > > May I ask whether you are using innodb or myisam? both on > > > > freebsd and Linux. And what filesystem are you using for > > > > mysql's data files? UFS, ZFS or anything else? > > >=20 > > > MySQL engine used is MEMORY, filesystem is ufs, but it's not > > > relevant. > > sure it is relevant. check my results: > > http://phoemix.harmless.hu/dbtests/ >=20 > 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 --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/hpnHH.TjDehp0Y1Xj/gBITA Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINFvNzrC0WyuMkpsRAgu3AJ495QlJDJBFMQ0vjrSw6BDd3krGhACfR6vR 849K1AWPnxY5TuYldxD8u1o= =vlar -----END PGP SIGNATURE----- --Sig_/hpnHH.TjDehp0Y1Xj/gBITA--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080521192843.30ca3833>