… which allows concurrent insert to work also if tables have “holes” (deleted rows) which can help significantly. delay_key_write Delay updating indexes…replication/binlogging related options – when to delete binary logs from master. It does not affect Innodb and other storage engines transaction logs…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 16, 2007 By 117 Comments
… run any benchmarks comparing InnoDB vs. MyISAM when queries are being done at the same time as new row creations. I had that situation a few years ago, and we tried InnoDB on the theory that… simultaneous select/creates if the table has no holes in it (we deferred all deletions until we could do a compact). That…
