On the consequences of sync_binlog != 1 (part #1) | J-F Gagné's MySQL Blog
A well-known performance booster in MySQL is to set sync_binlog to 0. However, this configuration alone comes with serious consequences on...| jfg-mysql.blogspot.com
I have been scratching my head about MySQL startup for some time. There is much to say about this, and many other posts will probably follo...| jfg-mysql.blogspot.com
A well-known performance booster in MySQL is to set sync_binlog to 0. However, this configuration alone comes with serious consequences on...| jfg-mysql.blogspot.com
Configuring Redo Log Capacity| dev.mysql.com
Have you ever needed to get some additional write throughput from MySQL ? If yes, you probably found that setting sync_binlog to 0 (and trx_commit to 2) gives you an extra performance boost. As all such easy optimisation, it comes at a cost. This talk explains how this tuning works, presents its consequences and makes recommendations to avoid them. This will bring us to the details of how MySQL commits transactions and how those are replicated to slaves. Come to this talk to learn how to...| archive.fosdem.org
Unleash your development potential with our comprehensive guide to the latest tools and resources in open source technology| Aiven
Aiven is growing fast and needs talent to continue our pace. If you’re ready to grow with us and do big things, check out who and what we’re looking for.| Aiven
Visit the Aiven blog to get the latest insights, product news, updates, and industry trends in open source data technology.| Aiven
innodb_adaptive_flushing| dev.mysql.com
--log-bin[=base_name]| dev.mysql.com
