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
5958
July 29, 2010 11:36PM
2026
July 31, 2010 09:13AM
2130
September 06, 2010 03:12PM
1861
September 06, 2010 09:56PM
1744
September 06, 2010 10:31PM
1645
September 06, 2010 11:51PM
1662
September 07, 2010 02:10AM
1651
September 07, 2010 10:38PM
2271
September 08, 2010 03:35AM
1682
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.