MySQL Forums
Forum List  »  MyISAM

Mixed engines within same database
Posted by: Greg Kuczek
Date: July 29, 2010 11:36PM

Hi *

is it the right observation? - when I created 2 tables in same db, one in InnoDB, the other in MyISAM, with bin-logs turned on, I've noticed that operations on data were logged for both of them. How come?
It also leverages recovery, I would say in a positive way, because I'm able to restore all tables.
The drawback however is the poorer performance of MyISAM that is meant to be fast due to less I/O operations, yet in this case it is not as it has additional writes to bin-logs just as the InnoDB table.

What's your opinion on it? Is it good to mix engines in one db? What is best practice in such cases?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mixed engines within same database
4542
July 29, 2010 11:36PM
1515
September 06, 2010 03:12PM
1417
September 06, 2010 09:56PM
1296
September 06, 2010 10:31PM
1204
September 06, 2010 11:51PM
1166
September 07, 2010 02:10AM
1214
September 07, 2010 10:38PM
1838
September 08, 2010 03:35AM
1182
September 25, 2010 09:00AM


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.