Index caches are new to 4.1.x, but key caches have been around for a while.
Definitely in 4.0, can't remember about 3.x.  Either way though, I don't see
either helping with inserts or updates.  Only with queries.

MySQL does suggest using a seperate key cache for temporary tables though:
http://www.mysql.com/doc/en/Multiple_key_caches.html

I haven't tried 4.11 yet (I'm just about to d/l it), but would expect it to
be pretty stable.

Eric


"Mark Maunder" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> The table I'm using is non-critical data, so it's not really an issue
> for me. But I was browsing through the mysql manual looking for a way to
> rebuild an MYI file from the .frm and MYD file (is there a way?) when I
> came across this:
>
> http://www.mysql.com/doc/en/CACHE_INDEX.html
>
> Index caches are only available in MySQL 4.11 unfortunately, so perhaps
> my ramdisk idea is a workaround for index caching until 411 is stable?
>
> On Mon, 2004-02-23 at 15:34, Eric B. wrote:
> > How are you ensuring syncronization between the ram disk and the HD?  Is
> > there a writeback / writethrough mechanism for ram disks?  Are you not
> > risking major data loss if ever you have a power failure or PC failure?
> >
> > Thanks for the info!
> >
> > Eric
> >
> > "Mark Maunder" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > Since HEAP tables don't support fulltext indexes, is moving MYISAM
> > > tables to ramdisk an acceptable workaround?
> > >
> > > On Sat, 2004-02-21 at 18:35, Mark Maunder wrote:
> > > > I've noticed a 4 times insert speed improvement by moving the MYI
index
> > > > file of a myisam table to a ramdisk. The MYD file is still on a
physical
> > > > disk, and I benchmarked the difference between moving just the index
> > > > file, or moving both, and it was only a 10% difference in speed. The
> > > > table has a large fulltext index.
> > > >
> > > > Has anyone else played with moving MYI files to ramdisk for
performance?
> > > > Any caveats that you know of, besides running out of ramdisk space?
> > > >
> > > >
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to