Currently I’m using MySQL 5.0 and InnoDB to store small database (1.1-1.8GB). I need extremely fast read access and moderate insert/update speed. On my dedicated server there is 4 GB RAM and I use 2GB as RAM drive where InnoDB bases are stored. Also InnoDB memory usage is set to minimal settings and 128MB log file (also placed on RAM disk).
Such combination gives me required speed but limits database size and requires extended backup features, etc.
My question is simple - is it possible to implement similar performance without RAM drive, just giving MySQL RAM that is now wasted on virtual drive.
Please, make comparative tests and post the results instead of just telling to “increase log size, may be it would help”.
Russian version of my question can be found here: http://www.mysqlperformanceblog.com/about/#comment-178034