TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients. Â However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers. Â The throughput scaling problem is caused by a poor interaction between the binary log group commit algorithm in MySQL 5.6 and the way TokuDB commits transactions. Â Â TokuDB 7.5.4 for Percona Server 5.6 fixes this problem, and the result isÂ roughly an order of magnitude increase in SysBenchÂ throughput for in memory workloads.
MySQL uses two phase commit protocol to synchronize the MySQL binary log …[Read more...]