“Using Asynchronous I/O by way of ‘io_uring’ Linux interface ought to actually assist enhance IO efficiency, resulting in decrease latencies. It is a large win for OLTP, the place time is all the things… We are going to possible see particularly good good points right here in environments with network-attached storage,” Lambert stated.
Asynchronous IO, in line with Percona’s Turner, permits database staff to concern a number of IO directions with out ready for earlier directions to finish, and this delivers efficiency good points by not blocking processing whereas ready for subsequent IO operations to begin.
Nevertheless, AIO for now helps disk-heavy reads and never writes, consultants identified, including that work is underway on bettering bulk writes and checkpoint writes. Examples of write-heavy OLTP workloads are car telemetry, social media, and on-line gaming platforms.
