--- title: AWS contributes a large-transaction binary log... description: AWS contributed an optimization called BOLT (Binary Log Optimization for Large Transactions) to community MySQL that removes a binlog commit bottleneck.... canonical: https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: AWS contributes a large-transaction binary log optimization to MySQL | daily.dev og:description: AWS contributed an optimization called BOLT (Binary Log Optimization for Large Transactions) to community MySQL that removes a binlog commit bottleneck.... og:url: https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj og:image: https://api.daily.dev/og/posts/41bjcOVgJ.png og:image:alt: AWS contributes a large-transaction binary log optimization to MySQL og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # AWS contributes a large-transaction binary log optimization to MySQL **[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 9 min read · 0 upvotes · 0 comments ## Summary AWS contributed an optimization called BOLT (Binary Log Optimization for Large Transactions) to community MySQL that removes a binlog commit bottleneck. Previously, committing a 50 GiB transaction could lock the binlog for about 7 minutes, blocking every other commit. With BOLT, commit latency for large transactions stays around 2 to 2.5 seconds regardless of size. It also speeds up crash recovery, cutting a 4-minute recovery for a 50 GiB transaction down to about 0.1 seconds in benchmarks, and improves throughput, roughly 2.8x to 3.1x in benchmarks. BOLT has run in Amazon Aurora MySQL since v1.22.0 and is planned for a future MySQL innovation release. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What does BOLT do to fix MySQL binlog commit latency for large transactions? BOLT (Binary Log Optimization for Large Transactions) promotes a transaction's spill file directly into the binlog sequence instead of copying its events into the main binlog file, making commit latency a small fixed cost independent of transaction size. In AWS benchmarks, a 50 GiB transaction's commit dropped from about 7 minutes to about 2.5 seconds. _Teams tuning MySQL commit latency can follow database engine changes like this on daily.dev._ ### How much faster is MySQL crash recovery with BOLT enabled for large transactions? Crash recovery of a large transaction drops to about 0.1 seconds with BOLT enabled, versus roughly 4 minutes for a 50 GiB transaction without it. This is because BOLT's Large_transaction_header_event stores the offset of the transaction's terminating event, letting recovery seek directly there instead of scanning the whole transaction body. _Ops teams planning MySQL failover behavior can track changes like this on daily.dev._ ### Which MySQL and Amazon Aurora versions include the BOLT binlog optimization? BOLT has been running in production in Amazon Aurora MySQL since v1.22.0, and it is enabled by default in all currently supported major versions: Aurora MySQL 2.x, 3.x, and 8.4.x. It is also planned to ship in a future MySQL community innovation release, with no required application changes. _Developers tracking Aurora and MySQL version upgrades can follow release details on daily.dev._ ## Similar posts on daily.dev - [Parallelizing MySQL Snapshots](https://daily.dev/posts/parallelizing-mysql-snapshots-ntjvrxuao) · Materialize · 0 upvotes · 0 comments - [MySQL 8.0.17 GTID Crash Safety Improvement](https://daily.dev/posts/mysql-8-0-17-gtid-crash-safety-improvement-0ktrivpzl) · Planet MySQL · 0 upvotes · 0 comments - [AWS Improves Aurora Serverless: 45% Faster Ramp-Up, 30% Higher Throughput](https://daily.dev/posts/aws-improves-aurora-serverless-45-faster-ramp-up-30-higher-throughput-k6d75rgau) · InfoQ · 23 upvotes · 0 comments - [Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL](https://daily.dev/posts/migrating-mission-critical-payments-at-nubank-to-amazon-aurora-postgresql-uhkwmxh9s) · AWS Database Blog · 5 upvotes · 0 comments --- Tags: [#aws](https://daily.dev/tags/aws), [#database](https://daily.dev/tags/database), [#mysql](https://daily.dev/tags/mysql) [View this post on daily.dev](https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"AWS contributes a large-transaction binary log optimization to MySQL","url":"https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj"},"datePublished":"2026-11-02T17:00:34.798Z","dateModified":"2026-11-02T17:01:10.048Z","description":"AWS contributed an optimization called BOLT (Binary Log Optimization for Large Transactions) to community MySQL that removes a binlog commit bottleneck....","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/7963aafda77ce0e88dc7cd1d226dda32?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/7963aafda77ce0e88dc7cd1d226dda32?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"AWS Database Blog","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS Database Blog","logo":"https://media.daily.dev/image/upload/s--En-avd2a--/f_auto,q_auto/v1780213446/logos/aws-database-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/aws-database-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,database,mysql","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS Database Blog","item":"https://daily.dev/sources/aws-database-blog"},{"@type":"ListItem","position":3,"name":"AWS contributes a large-transaction binary log optimization to MySQL"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-41bjcovgj#faq","mainEntity":[{"@type":"Question","name":"What does BOLT do to fix MySQL binlog commit latency for large transactions?","acceptedAnswer":{"@type":"Answer","text":"BOLT (Binary Log Optimization for Large Transactions) promotes a transaction's spill file directly into the binlog sequence instead of copying its events into the main binlog file, making commit latency a small fixed cost independent of transaction size. In AWS benchmarks, a 50 GiB transaction's commit dropped from about 7 minutes to about 2.5 seconds. Teams tuning MySQL commit latency can follow database engine changes like this on daily.dev."}},{"@type":"Question","name":"How much faster is MySQL crash recovery with BOLT enabled for large transactions?","acceptedAnswer":{"@type":"Answer","text":"Crash recovery of a large transaction drops to about 0.1 seconds with BOLT enabled, versus roughly 4 minutes for a 50 GiB transaction without it. This is because BOLT's Large_transaction_header_event stores the offset of the transaction's terminating event, letting recovery seek directly there instead of scanning the whole transaction body. Ops teams planning MySQL failover behavior can track changes like this on daily.dev."}},{"@type":"Question","name":"Which MySQL and Amazon Aurora versions include the BOLT binlog optimization?","acceptedAnswer":{"@type":"Answer","text":"BOLT has been running in production in Amazon Aurora MySQL since v1.22.0, and it is enabled by default in all currently supported major versions: Aurora MySQL 2.x, 3.x, and 8.4.x. It is also planned to ship in a future MySQL community innovation release, with no required application changes. Developers tracking Aurora and MySQL version upgrades can follow release details on daily.dev."}}]} ```