Multiple page asynchronous I/O requests

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.

InnoDB uses Linux asynchronous I/O (aio) by default. By submitting multiple consecutive 16KB read requests at once, Linux internally can merge requests and reads can be done more efficiently.

On a HDD RAID 1+0 environment, more than 1000MB/s disk reads can be achieved by submitting 64 consecutive pages requests at once, while only 160MB/s disk reads is shown by submitting single page request.

With this feature InnoDB submits multiple page I/O requests.

Version Specific Information

  • 5.6.38-83.0- Feature ported from the Facebook MySQL patch.

Status Variables

variable Innodb_buffered_aio_submitted
Version Info:
  • 5.6.38-83.0 – Implemented
Variable Type:




This variable shows the number of submitted buffered asynchronous I/O requests.

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.