MySQL Forums
Forum List  »  InnoDB

Re: Need suggestion: Using InnoDB and MyISAM together
Posted by: Aftab Khan
Date: March 13, 2009 05:28AM

Only you know which tables are transactional ( or will be a part of transaction, and in case of tx failure myisam data will no be accurate) , so, think and only convert those which are transactional, to be honest you can have combination of myisam, memory, innodb, federated etc.. tables in one database ( they can co-exist)
or if your are not sure then simply convert all of them but before you do the transition, you will need to adjust innodb_buffer_pool_size, innodb_log_file_size ( How much RAM is available??).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need suggestion: Using InnoDB and MyISAM together
2413
March 13, 2009 05:28AM


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.