mysql performance on freebsd 7
gergely.czuczy at harmless.hu
Wed May 21 17:28:48 UTC 2008
On Wed, 21 May 2008 19:03:55 +0200
Tomasz Pajor <nikon at 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?
> > >
> > > 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/
> 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
mailto: gergely.czuczy at harmless.hu
Legacy software is software that works.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20080521/574be1e8/signature.pgp
More information about the freebsd-performance