MySQL Forums
Forum List  »  Performance

Re: InnoDB vs. MyISAM: RAM Needed?
Posted by: Peter Zaitsev
Date: February 04, 2005 11:53AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3774
February 03, 2005 10:22AM
2861
February 03, 2005 08:40PM
Re: InnoDB vs. MyISAM: RAM Needed?
2543
February 04, 2005 11:53AM
1920
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.