Rate This Document
Findability
Accuracy
Completeness
Readability

Binlog Lock Splitting

Application scenario: MySQL write-only OLTP

Technical principle: Locks are split so that followers in different phases wait for different locks, reducing the possibility of false wakeups between different groups. This reduces the system overhead associated with pthread_cond_wait/pthread_cond_broadcast calls and alleviates lock conflicts.

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 5%.