Showing entries 1 to 2
Displaying posts with tag: Free Page (reset)
Dec
13
2022
Free Page Consumption by InnoDB Table Compression (Percona backoff Algo. part #2)
Posted by Jean-François Gagné on Tue 13 Dec 2022 01:06 UTC
Tags:

In my previous post about InnoDB Stalls on Empty Free List, I used a test environment that might look a little artificial : a table larger than the InnoDB Buffer Pool but fitting in the Linux Page Cache.  This configuration allows serving very quickly what MySQL thinks are IOs because these are hit in the filesystem cache.  In this post, I explain why this environment is not

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 2