Binlog Pre-Allocation

Application scenario: MySQL write-only OLTP

Technical principle: The size of binlog files when being created is pre-allocated as max_binlog_size. This prevents metadata operations caused by dynamic file size growth during writes, thereby reducing I/O overhead and improving system performance.

Performance metric: The sysbench write-only tests show that the feature can improve the performance of Percona-Server 5.7.44-53 running on a container with 8 vCPU and 16 GB memory by 2%.