Showing entries 1 to 1
Displaying posts with tag: Tail Latencies (reset)
Nov
30
2022
Tail Latencies in Percona Server because of InnoDB Stalls on Empty Free List
Posted by Jean-François Gagné on Wed 30 Nov 2022 23:43 UTC
Tags:

If, in Percona Server, you are observing tail latencies on queries that should be fast, this might be a side effect of Percona's improved InnoDB Empty Free List Algorithm.  When using this algorithm (the default in 5.6 and 5.7 and optional configuration in 8.0), a query needing a free page while none are available waits until the LRU Manager Thread refills the free list.  Because this

Showing entries 1 to 1