Mixed engines within same database
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?
Subject
Views
Written By
Posted
Mixed engines within same database
5929
July 29, 2010 11:36PM
2017
July 31, 2010 09:13AM
2118
September 06, 2010 03:12PM
1855
September 06, 2010 09:56PM
1737
September 06, 2010 10:31PM
1634
September 06, 2010 11:51PM
1655
September 07, 2010 02:10AM
1644
September 07, 2010 10:38PM
2264
September 08, 2010 03:35AM
1672
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.