mysql performance on freebsd 7

CZUCZY Gergely 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


-- 

Sincerely,

Gergely CZUCZY,
Harmless Digital
mailto: gergely.czuczy at harmless.hu

Legacy software is software that works.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
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 mailing list