|
This is to be expected, by design. If the throttling parameter is nonzero, there will be some overhead involved with managing “concurrency tickets” that could become a bottleneck by itself.
Some parameters related to working around scalability bottlenecks were deprecated and ignored in MariaDB Server 10.5 by MDEV-23379, and removed from MariaDB Server 10.6 in MDEV-23397. I think that the original motivation around these was contention on buf_pool.mutex or the kernel_mutex that was later split into trx_sys.mutex, lock_sys.mutex and many others.
The contention on mutexes or rw-locks depends somewhat on the type of workload. For MDEV-29401 I recently collected statistics for a particular type of read-only workload. It is dominated by the following InnoDB latches:
For write-heavy workloads, log_sys.mutex or the 10.8+ log_sys.latch should dominate, and there could be some contention on buf_pool.flush_list_mutex as well.
I am reluctant to work on any performance improvements of older releases than 10.6.
|