MariaDB Enterprise Server InnoDB I/O Threads

Learn about the specialized I/O threads in MariaDB Enterprise Server's InnoDB engine that handle asynchronous read and write operations efficiently.

Overview

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		MariaDB Enterprise Server
Quantity	Set by innodb_read_io_threads and innodb_write_io_threads	Configure the InnoDB I/O 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     |
+-------------------------+-------+

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}