# AWS contributes a large-transaction binary log optimization to MySQL

DevFeed: [AWS contributes a large-transaction binary log optimization to MySQL](<https://devfeed.tech/articles/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-112630.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql/>)

Author: Xueting Wu

Published: 2026-11-02T16:57:08Z

Content type: news

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [transaction-log](<https://devfeed.tech/topics/transaction-log.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bolt](<https://devfeed.tech/tags/bolt.md>), [crash-recovery](<https://devfeed.tech/tags/crash-recovery.md>), [large](<https://devfeed.tech/tags/large.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [rds-for-mysql](<https://devfeed.tech/tags/rds-for-mysql.md>), [throughput](<https://devfeed.tech/tags/throughput.md>), [transaction](<https://devfeed.tech/tags/transaction.md>)

## AI overview

BOLT removes the large-transaction binlog copy that can block all MySQL commits: once a transaction exceeds a configurable threshold (128 MB by default), MySQL promotes its spill file into the binlog sequence. A header event lets crash recovery seek to the transaction's end instead of scanning its contents. In the described controlled benchmarks, a 50 GiB transaction's commit took about 2.5 seconds with BOLT versus about 7 minutes without it; binlog recovery took about 0.1 seconds versus about 4 minutes. Throughput also rose in tested workloads containing large transactions. These results are benchmark-specific, and remaining commit time includes durable spill-file writes and InnoDB commit. BOLT is enabled by default in Aurora MySQL; a future MySQL innovation release is planned. Large transactions can still reduce replica parallelism and cause lag, so the post recommends batching them where the application allows.

## Source excerpt

When MySQL commits a large transaction, writing it to the binary log can freeze every other commit on the server for minutes. This post introduces Binary Log Optimization for Large Transactions (BOLT), an AWS contribution to community MySQL that makes commit latency independent of transaction size, speeds crash recovery, and improves throughput.