Hey. We have the need to have some tables stored in memory for performance reasons.
We were thinking about just using MEMORY tables but this is non ideal since it uses a fixed row size. Using MyISAM would be much better since it supports variable length rows. Backups would be handled by just using mysqlhotcopy and snapshotting the tables to disk either on the master or the slave. Has anyone done this and have they had any problems? Kevin -- Founder/CEO Tailrank.com Location: San Francisco, CA AIM/YIM: sfburtonator Skype: burtonator Blog: feedblog.org Cell: 415-637-8078