mysql performance on freebsd 7
gergely.czuczy at harmless.hu
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 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
> "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
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/74466346/signature.pgp
More information about the freebsd-performance