MySQL Forums :: MyISAM :: Mixed engines within same database


Advanced Search

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 4478 Greg Kuczek 07/29/2010 11:36PM
Re: Mixed engines within same database 1491 Rick James 07/31/2010 09:13AM
Re: Mixed engines within same database 1497 DBA Lead 09/06/2010 03:12PM
Re: Mixed engines within same database 1402 Rick James 09/06/2010 09:56PM
Re: Mixed engines within same database 1287 DBA Lead 09/06/2010 10:31PM
Re: Mixed engines within same database 1184 Greg Kuczek 09/06/2010 11:51PM
Re: Mixed engines within same database 1155 Aftab Khan 09/07/2010 02:10AM
Re: Mixed engines within same database 1199 Rick James 09/07/2010 10:38PM
Re: Mixed engines within same database 1823 Aftab Khan 09/08/2010 03:35AM
Re: Mixed engines within same database 1164 Rick James 09/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.