Remember when Percona significantly improved query processing time by fixing the optimizer bug? I have described all the details in More Performant Query Processing in Percona Server for MySQL blog post. This time, we dug deeper into all the ideas from Enhanced for MySQL and based on our analysis, we proposed several new improvements. All the changes are available in Percona Server 8.0.43 and 8.4.6, and newer versions
Before discussing specific improvements, let me describe how we measured the kind of performance gain we achieved. The top-level approach is common for benchmarks: you need a baseline version and then compare your modified version to that baseline. At Percona, we have a dedicated environment for performance testing. …
[Read more]