MariaDB Enterprise Server InnoDB I/O Threads
This page is part of MariaDB's Documentation.
The parent of this page is: InnoDB Architecture for MariaDB Enterprise Server
Topics on this page:
Overview
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 |
| |
Quantity | Set by innodb_ |
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 |
+-------------------------+-------+