I am trying to determine the difference in durability between MySQL's MyISAM and InnoDB when
I am aware of the some of the benefits of InnoDB with ACID. However, under the default settings inserts with InnoDB are too slow. Changing
innodb_flush_log_at_trx_commit speeds things up, but we could loose about 1 or so seconds of data (which we are rather ok with).
innodb_flush_log_at_trx_commit set to 0 (or 2) is InnoDB more durable than MyISAM? Is it less susceptible to data corruption? Or does it essentially reduce InnoDB's durability and corruption to that of MyISAM?
Any thoughts on the differences?