Re: [Maria-developers] what pros/cons of storing binary log in an InnoDB table?

Stewart Smith <[email protected]> Tue, 29 Jan 2013 12:05:30 +1100

Newsgroups	gmane.comp.db.mysql.devel
Message-ID	<[email protected]>

Kristian Nielsen <[email protected]> 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

signature.asc (application/pgp-signature, 835 B)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBAgAGBQJRByBbAAoJEP08notdpDyv1BUP/Ry3mZESe6TzSFsmIdjjgNW7
yXckABlbBUp4NXQ58lLgVtuiLb+1W9ZEU8UNLnXExaAt3WGCzs6ua8MiRjbT5KQ7
QBTaizz54YnmD/CZbqjO0050aaTBl3dck6JyIlcRNCCzJQFCfSycHRlERw4DUMrw
Hd3T6IQoJKFbO92nykJJ/SNuvPS7sE9k5if7XHpsNR1yRIJxK8yiLDicnbBc6GR5
KQweHUtkvr9OKxwCRKXgP85KWyRWe0m/U1cqmIvP6S7myo+Z2I8jQXgoOib4cwIl
BMp5m9HoFdo3HU+93DPJiS/UEFTahQIDq8KTdegfW6aoMuRFKKwEy6pitSJEZtFj
5BjX0q3tWN54PqRt05C2SrihEB+T/zti5z4ZEdzQXYTW551Bswcka7RQyrpI7aRo
7E13cL8RHJ9L2U+L1ZblNv8rU8BuRYKgu++a2bYeHUwAvrWhi2obQJJrsOWIEJ0l
SEY10QtGDBycjuMR0n98IgaE5jyP7IX0eGzDJLfReaBxCWSyVdOcZ6wBNMkug/pM
KDU6N8oQYTmdhq9nc3GGIXzrG7LCUPdW3hnNLwwSDUTnm0J0OSvfm+Xyt2yIfnZo
koFX38TECEN/dzRqLIqAU53qFAtUTHpsv4O+eIXB8UNJ8Ov+/EbTEosrF+d2JjWe
Mv2KYaKLPOq0KKMf8BRK
=C+G0
-----END PGP SIGNATURE-----