Re: keeping whole database in RAM
Posted by:
Rick James
Date: October 15, 2008 10:59PM
Yes and no.
The Yes...
In InnoDB, set innodb_buffer_pool_size to at least 500M. Then it will all be cached.
In MyISAM, set key_buffer_size to be large enough to hold all the indexes (look in file system for .MYI files). The data will be cached by the OS.
In MEMORY (also called HEAP), the table is entirely in RAM and never hits the disk.
The No...
Writes will continue to go to disk. There is no way to automatically load it all into RAM. If you have a power failure, well...
And, yes, it will be much faster than if it had to read from the disk.
Subject
Written By
Posted
Re: keeping whole database in RAM
October 15, 2008 10:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.