MySQL Binlog Optimization

Application scenario: MySQL write-only OLTP scenarios

Technical principles: The binlog pre-allocation, lock splitting, and writeset_history data structure optimization are used to improve system performance.

Performance metric: 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 13%.

Figure 1 Performance comparison