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
6711
July 29, 2010 11:36PM
2255
July 31, 2010 09:13AM
2615
September 06, 2010 03:12PM
2092
September 06, 2010 09:56PM
2180
September 06, 2010 10:31PM
2071
September 06, 2010 11:51PM
2106
September 07, 2010 02:10AM
1864
September 07, 2010 10:38PM
2647
September 08, 2010 03:35AM
1939
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.