MariaDB Enterprise Server InnoDB I/O Threads

In versions up to MariaDB Enterprise Server 10.4 and MariaDB Community Server 10.4, InnoDB uses the InnoDB I/O Threads to handle completion of I/O requests in the background. The InnoDB Read I/O Threads handle completion of read I/O requests, and the InnoDB Write I/O Threads handle completion of write I/O requests.

Starting with MariaDB Enterprise Server 10.5 and MariaDB Community Server 10.5, the InnoDB I/O Threads were replaced by the asynchronous I/O functionality in the InnoDB Background Thread Pool.

Feature Summary

Feature

Detail

Resources

Thread

InnoDB I/O Threads

Storage Engine

InnoDB

Purpose

Reading data from disk / Writing data to disk

Availability

  • ES 10.4 and Before

  • CS 10.4 and Before

Quantity

Set by innodb_read_io_threads and innodb_write_io_threads

Basic Configuration

[mariadb]
...
innodb_read_io_threads=8
innodb_write_io_threads=8
SET GLOBAL innodb_read_io_threads=8;
SET GLOBAL innodb_write_io_threads=8;

SHOW GLOBAL VARIABLES
   LIKE 'innodb_%_io_threads';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| innodb_read_io_threads  | 8     |
| innodb_write_io_threads | 8     |
+-------------------------+-------+