I have the following case:
My database size is approximately equal to or a little bit above the physical ram size available(500M to 1Gb). I use InnoDB tables. Performance is a critical aspect for the application i build above this database so the idea to keep most of the db blocks in the cache is quite attractive.
Is there a possibility to quickly load most of the blocks into innodb cache(or just perform full scan?) so that the sistem obtains high performance from the start?
Are there any recommendations for the systems like that - when data persistence is important, but also enough ram available and select queries performance is critical?