mysql performance on freebsd 7

[CZUCZY Gergely]

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 kei.pl> 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  
> 
> http://dev.mysql.com/doc/refman/5.1/en/memory-storage-engine.html
> 
> "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


-- 

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/74466346/signature.pgp