Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: innodb_lru_scan_depth (reset)

Nov

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:

innodb, sysbench, flushing, percona server, stalls, MySQL, dbdeployer, backoff, Free List, Free Page, Innodb_buffer_pool_wait_free, innodb_empty_free_list_algorithm, innodb_lru_scan_depth, Tail Latencies

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

The latest from the MySQL community

Get Started Contributing

Events

MySQL Showcase

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links