Learn extra at:
“The usage of 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 pieces… We are going to probably see particularly good good points right here in environments with network-attached storage,” Lambert mentioned.
Asynchronous IO, based on Percona’s Turner, permits database employees to difficulty 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 start out.
Nonetheless, AIO for now helps disk-heavy reads and never writes, specialists 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.