Bounder Posted April 27, 2008 Share Posted April 27, 2008 Is there an option in MySQL to have all the data just be cached in memory at startup and whenever something is changed have it changed in memory also, so that no disk seeks will be needed for selects? If not, is there a ram disk software for xp 64bit that can do this (save changes to disk in real time, but read from memory) and is reliable? (I found one but it kept corrupting data, which isn't acceptable) Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 27, 2008 Share Posted April 27, 2008 Did you look at HEAP storage engine? Quote Link to comment Share on other sites More sharing options...
Bounder Posted April 27, 2008 Author Share Posted April 27, 2008 Yes, but I can't be having data loss. The data needs to be reliable saved to hard drive. When an insert/update/replace is performed, not half an hour later by a cron job. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 27, 2008 Share Posted April 27, 2008 Edit: Didnt see your bit about having it run to disk only on update etc Quote Link to comment Share on other sites More sharing options...
fenway Posted April 28, 2008 Share Posted April 28, 2008 Why does everyone want to do this? Leave the I/O and memory handling to mysql. See this thread, too. You can't have it in memory only and be reliable. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.