Enhancing MySQL: Performance, Stability, and High Availability

To better serve MySQL users, we have optimized MySQL 8.0.41 comprehensively. The specific optimizations include improvements to InnoDB storage engine scalability, redo log optimization, resolution of the join performance degradation issue since version 8.0.28, mitigation of bulk insert performance issues, resolution of performance degradation issues in certain scenarios related to query execution plans, binlog group commit optimization, memory usage optimization, high availability enhancements, and secondary replay architecture optimization. These improvements are based on data structures, algorithms, and logical reasoning, aiming for simplicity and efficiency while streamlining the MySQL optimization process.

Extensive testing has shown that these optimizations are especially effective on high-performance hardware. The optimized MySQL 8.0 delivers more stable and efficient service to users.

Our Improvements

Resolution of Performance Degradation Issues Since Version 8.0.28: Join performance restored to previous levels.
Bulk insert performance improvement: Replacing the deque data structure mitigated the performance degradation.
InnoDB Storage Engine Enhancements: Improved scalability and redo log performance in specific scenarios.
Performance Optimization for Binlog Group Commits.
Resolution of Performance Degradation Issues in Query Execution Plans.
Replica Replay Optimization: Accelerated replay speed on replicas to ensure consistent reads.
Addressing Performance Issues Due to Poor MySQL NUMA Compatibility.
Mature High Availability Product: Improved Paxos protocol and protocol interactions, along with better design and enhanced cluster write performance.

These improvements are designed to enhance MySQL’s performance in high-throughput environments, achieve consistent reads, and address various failure issues, ensuring high availability and performance in high-concurrency scenarios, making it particularly suitable for internet companies

Note

The better the hardware environment, the greater the performance gap with the official version as concurrency increases.
Use testing tools that closely resemble the online environment, such as BenchmarkSQL, to effectively showcase performance advantages. If possible, utilize TCPCopy to replicate online traffic for testing.
During testing, the concurrency limit should not exceed 1000, as the current throttling mechanism has not been open-sourced.
It is recommended to align MySQL configuration parameters with our settings, making adjustments based on the specific hardware.
For high availability, we adopted the single-primary mode of Group Replication but removed the conflict detection part, making it a fully state machine-based approach.
Due to differences in the underlying data format of Paxos communication, it is incompatible with the official version during runtime, but compatible when offline. A restart of all nodes is required to complete the transition.
For the improved Group Replication, we also have a highly mature middleware to provide support. For more details, refer to the project at Cetus.
For more information, refer to the main project: enhancedformysql.

References

For detailed principles and mechanisms behind our improvements, please refer to the following book：The Art of Problem-Solving in Software Engineering:How to Make MySQL Better

Bugs and Feature Requests

MySQL continues to offer numerous optimization opportunities of significant interest. If users experience any performance-related issues during actual use, please open a new issue. Before submitting a new issue, please check for any existing ones.

Copyright and License

Copyright 2025 under GPLv2.

License

enhancedformysql/mysql-8.0.41

ErrorLooks like something went wrong!

About

Resources

License

Security policy

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages