maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #05086
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
References