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??).
Subject
Views
Written By
Posted
4650
March 13, 2009 01:08AM
2091
March 13, 2009 01:22AM
2037
March 13, 2009 03:00AM
2066
March 13, 2009 03:23AM
2166
March 13, 2009 04:05AM
Re: Need suggestion: Using InnoDB and MyISAM together
2413
March 13, 2009 05:28AM
1940
March 13, 2009 09:13AM
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.