Clever Geek Handbook

MySQL databases with MEMORY storage engine saved to disk?

If MySQL databases with the MEMORY engine are stored in memory, does that mean that their contents are not saved to disk? Or are they stored on the hard drive but are fully loaded into RAM when the system is turned on?

+2


source to share


2 answers


There is one single disk file containing the database definition , but the data is never flushed to disk. Data is lost when the server shuts down.

http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html



When tables get too large, you just get errors. However, like any other memory usage, it can be swapped out ... and then use some disk.

+4


source


The content is not saved to disk, they are lost when the server is turned off. This is the ideal table type for temporary data.



More details here: http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html

+1


source






More articles:


All Articles