Re: Mixed engines within same database
Mixing MyISAM and InnoDB is fine. The binlog is designed for Replication; all writes to all Engines need to be written to the binlog.
sync_binlog is a setting that somewhat controls the overhead of binlog. It is a tradeoff between security and speed.
A RAID controller with a battery-backed-write-cache does wonders for the sluggishness you describe.
Subject
Views
Written By
Posted
6239
July 29, 2010 11:36PM
Re: Mixed engines within same database
2110
July 31, 2010 09:13AM
2239
September 06, 2010 03:12PM
1940
September 06, 2010 09:56PM
1825
September 06, 2010 10:31PM
1774
September 06, 2010 11:51PM
1738
September 07, 2010 02:10AM
1728
September 07, 2010 10:38PM
2389
September 08, 2010 03:35AM
1819
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.