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? > > -- Mark Maunder <[EMAIL PROTECTED]> ZipTree.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
