Re: InnoDB vs. MyISAM: RAM Needed?
The question is not entirely correct. As James mentioned you can configure MySQL to use just a bit more memory with Innodb, however performance will be low.
Reaching performance similar to MyISAM is not possible in all cases, ie due to transaction overhead, but if you want close performance of reads you need to have similar fit of Innodb tables into cache. Innodb tables can take twice the space MyISAM tables have (or even more).
Note MyISAM only caches indexes in "key_cache" while Innodb caches everything in "innodb_buffer_pool" so you normally have innodb_buffer_pool significantly larger than key_cache on migration.
Subject
Views
Written By
Posted
3934
February 03, 2005 10:22AM
2955
February 03, 2005 08:40PM
Re: InnoDB vs. MyISAM: RAM Needed?
2634
February 04, 2005 11:53AM
2015
February 08, 2005 01:56PM
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.