maria-developers team mailing list archive
Mailing list archive
Re: what pros/cons of storing binary log in an InnoDB table?
Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx> writes:
> You will be writing your data *6* times: To the real table, when flushing its
> buffer pool pages. To the double-write buffer while flushing, and to the redo
> log before flushing. Then to the binlog table, and before that to the redo log
> and the doublewrite buffer. I could never reconcile myself with this.
Mind you, it performs really quite well due to the reduced fsync()s and
(at least in Drizzle code) was rather trivial to implement. Big bang for
Description: PGP signature