Re: mysql performance on freebsd 7

On Wed, 21 May 2008 19:03:55 +0200
Tomasz Pajor <nikon@xxxxxx> 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@xxxxxxxxxxx

Legacy software is software that works.

Attachment: signature.asc
Description: PGP signature

Relevant Pages

  • Re: mysql performance on freebsd 7
    ... MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. ... Legacy software is software that works. ...
    (freebsd-performance)
  • Re: mysql performance on freebsd 7
    ... MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. ...
    (freebsd-performance)
  • Re: mysql performance on freebsd 7
    ... MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. ...
    (freebsd-performance)
  • AIX 5.2 maxperm & Oracle
    ... maxperm was set to 63%, ... large volumes of data IO going through the AIX filesystem cache). ... for memory with filesystem cache. ...
    (comp.unix.aix)
  • Re: [00/17] Large Blocksize Support V3
    ... to lock the filesystem block and prevent any updates to it, ... get 128 pages into a bio so all we've done churned some in memory ... I/O no faster than the current code. ... We can't use buffer heads - they can only point ...
    (Linux-Kernel)