[MDEV-11378] AliSQL: [Perf] Issue#23 MERGE INNODB AIO REQUEST - Jira

XML

Word

Printable

Description:

------------

The InnoDB engine support native AIO and simulated AIO on linux platform.

Native AIO use io_submit that glibc supplied to request IO.

But InnoDB engine requested AIO one by one through io_submit when trigger read-ahead,

so it is a little inefficiency.

Solution:

---------

We buffered the AIO requests, then io_submit all.

For example: when linear-ahead. we buffered next 64 pages io requests,

at last, io_submit all io requests.

relates to

MDEV-26547 Restoring InnoDB buffer pool dump is single-threaded for no reason

MDEV-30986 Slow full index scan in 10.6 vs 10.5 for the (slow) I/O-bound case

MDEV-32067 InnoDB linear read ahead had better be logical

MDEV-16526 Overhaul the InnoDB page flushing

MDEV-31095 Create separate tpool thread for async aio

MDEV-31492 Provide a way to "pin" InnoDB table in memory

(1 relates to)