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]
