MariaDB Enterprise Server InnoDB Background Thread Pool

This page details the dedicated thread pool in MariaDB Enterprise Server that manages InnoDB background tasks, improving scalability and performance.

Overview

InnoDB uses the InnoDB Background Thread Pool to perform internal operations in the background instead of dedicated threads. By using the InnoDB Background Thread Pool instead of many dedicated threads, InnoDB can reduce context switching and use system resources more effectively.

The InnoDB Background Thread Pool performs internal operations in multiple categories: tasks, timers, and asynchronous I/O.

Tasks are used to perform internal operations that are triggered by some event. The following threads have been replaced by tasks with the InnoDB Background Thread Pool:

The InnoDB Buffer Pool Resize Thread
The InnoDB Buffer Pool Dump Thread
The InnoDB Full-Text Search (FTS) Optimization Thread

Timers are used to perform internal operations that are triggered periodically. The following threads have been replaced by timers with the InnoDB Background Thread Pool:

The InnoDB Master Thread
The InnoDB Defragmentation Thread
The InnoDB Monitor Thread
The InnoDB Error Monitor Thread

Asynchronous I/O is used to read from and write to disk asynchronously. The following threads have been replaced by asynchronous I/O with the InnoDB Background Thread Pool: