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) Link to comment https://forums.phpfreaks.com/topic/103115-read-data-from-memory-instead-of-hard-disk-drive/ Share on other sites More sharing options...
mwasif Posted April 27, 2008 Share Posted April 27, 2008 Did you look at HEAP storage engine? Link to comment https://forums.phpfreaks.com/topic/103115-read-data-from-memory-instead-of-hard-disk-drive/#findComment-528192 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. Link to comment https://forums.phpfreaks.com/topic/103115-read-data-from-memory-instead-of-hard-disk-drive/#findComment-528200 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 Link to comment https://forums.phpfreaks.com/topic/103115-read-data-from-memory-instead-of-hard-disk-drive/#findComment-528324 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. Link to comment https://forums.phpfreaks.com/topic/103115-read-data-from-memory-instead-of-hard-disk-drive/#findComment-528826 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.