Thread Pool in Percona Server and MySQL (Part 1)

Community MySQL Server's July release (26.7.0 and 9.7.2) finally brings thread pooling to non-Enterprise users, a feature previously exclusive to MySQL Enterprise Edition and already present in Percona Server. This first part of a two-part series benchmarks Percona Server's thread pool implementation using Sysbench OLTP Read-Write across varying thread_pool_size, oversubscription levels, connection counts, and buffer-to-data ratios. Results show thread pooling delivers dramatic gains in I/O-bound scenarios (up to 17.9x TPS improvement at 2560 connections) but offers no TPS benefit, and even a slight slowdown, when the dataset is fully buffered in memory. However, even without TPS gains, thread pooling significantly tightens p95 latency (235-297ms vs 787ms without pooling), improving predictability for the slowest 5% of transactions. Tuning thread_pool_size and oversubscribe values carefully is critical, since suboptimal settings can cause steep performance drops. Part 2 will compare Percona Server against the new MySQL Server thread pool implementation.

Nguồn: https://www.percona.com/blog/thread-pool-in-percona-server-and-mysql-part-1. 8 Sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.