Comments on: InnoDB Performance Optimization Basics https://www.percona.com/blog/innodb-performance-optimization-basics-updated Mon, 02 Oct 2023 14:21:41 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Jakub Łopuszański https://www.percona.com/blog/innodb-performance-optimization-basics-updated/#comment-10974031 Mon, 27 Mar 2023 20:55:21 +0000 https://www.percona.com/blog/?p=86300#comment-10974031 > innodb_deadlock_detect (Dynamic) – This option can be used to disable deadlock
> detection. On high-concurrency systems, deadlock detection can cause a slowdown when > numerous threads wait for the same lock.

I hope this is no longer a problem at least since 2019 (MySQL 8.0.18) when I’ve introduced a dedicated background deadlock detector thread which most of the time is latch-free.
Do you have some recent benchmarks showing impact of this option?

]]>