mysql performance on freebsd 7

CZUCZY Gergely gergely.czuczy at
Wed May 21 18:41:14 UTC 2008

ahh, sorry. missunderstood that. i've seen many places they've put the
data into memory disks. i've thought that's being done here also.

On Wed, 21 May 2008 19:33:56 +0200
Tomasz Pajor  <nikon at> wrote:

> > > 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  
> "As indicated by the name, MEMORY tables are stored in memory. They
> use hash indexes by default, which makes them very fast, and very
> useful for creating temporary tables. However, when the server shuts
> down, all rows stored in MEMORY tables are lost. The tables
> themselves continue to exist because their definitions are stored
> in .frm files on disk, but they are empty when the server restarts."
> so only the structure is in file not data



Gergely CZUCZY,
Harmless Digital
mailto: gergely.czuczy at

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 :

More information about the freebsd-performance mailing list