← Back to team overview

maria-developers team 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
buck :)

Stewart Smith

Attachment: pgpQwNvbRrYFs.pgp
Description: PGP signature

Follow ups