Is Thread Pool Plugin the Right Choice for Your Workload?
Percona
JANUARY 2, 2024
We decided to run a few benchmarks to understand how the thread pool affects long-running transactions. When analyzing the workload, I found that the performance drop was caused by applications executing some very long queries like UPDATE affecting many rows, INSERT… SELECT without limit clause and other similar DMLs.
Let's personalize your content