Merge AIO page read requests (5.6)
https:/
Submitting multiple async I/O requests at once
http://
Currently i/o unit size in InnoDB is only one page, even if doing read ahead. 16KB i/o unit size is too small for sequential reads, and much less efficient than larger I/O unit size.
In 5.6 InnoDB uses Linux Native I/O (aio) by default. If submitting multiple consecutive 16KB read requests at once, Linux internally can merge requests and reads can be done more efficiently.
See MySQL Bug #68659 (https:/
The suggested fix is to make InnoDB submit multiple page i/o requests before calling io_submit().
Original WebScaleSQL commit:
https:/
Facebook MySQL 5.6 commit:
https:/
Blueprint information
- Status:
- Complete
- Approver:
- Laurynas Biveinis
- Priority:
- High
- Drafter:
- Yura Sorokin
- Direction:
- Approved
- Assignee:
- Yura Sorokin
- Definition:
- Approved
- Series goal:
- Accepted for 5.6
- Implementation:
-
Implemented
- Milestone target:
-
5.6.38-83.0
- Started by
- Laurynas Biveinis
- Completed by
- Yura Sorokin