Posted On: Apr 24, 2023
Amazon Relational Database Service (Amazon RDS) for MySQL and MariaDB now support Optimized Reads for up to 2X faster query processing compared to previous generation instances. Optimized Read-enabled instances achieve faster query processing by placing temporary tables generated by the MySQL and MariaDB server on the NVMe SSD-based block-level instance storage that’s physically connected to the host server. Complex queries that utilize temporary tables, such as queries involving sorts, hash aggregations, high-load joins, and Common Table Expressions (CTEs) can now execute up to 2X faster with Optimized Reads on RDS for MySQL and MariaDB.
Optimized Reads is available by default on RDS for MySQL versions 8.0.28 and higher, and MariaDB versions 10.4.25, 10.5.16, 10.6.7 and higher on Intel-based M5d and R5d instances and Amazon Graviton2-based R6gd database (DB) instances. R5d and M5d DB instances provide up to 3,600 GiB of NVMe SSD-based instance storage for low latency, high random I/O and sequential read throughput. R6gd DB instances are built on the Amazon Nitro System, and provide up to 3,800 GiB of NVMe-based SSD storage and up to 25 Gbps of network bandwidth.
Optimized Reads for Amazon RDS for MySQL and MariaDB is available today on M5d, R5d and R6gd instances in the same regions where these instances are available. For complete information on pricing and regional availability, please refer to the Amazon RDS Pricing.
To learn more about the Optimized Reads feature on Amazon RDS for MySQL and MariaDB, refer to the Amazon RDS User Guide. You can launch a new Optimized Read Workload in the Amazon RDS Management Console.
Amazon RDS for MySQL makes it easy to set up, operate, and scale MySQL and MariaDB deployments in the cloud. Amazon RDS for MySQL and MariaDB are available in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD.