A naukri.com initiative
Amazon
1d
235
Image Credit: Amazon
Enhancing performance of Amazon RDS for Oracle with NVMe SSD hosted Smart Flash Cache and Temporary Tablespaces
- Amazon RDS for Oracle now supports Non-Volatile Memory Express (NVMe) SSD devices in physical attachment and optimizing low latency, random I/O performance, and sequential read throughput for temporary tablespaces and flash cache features.
- NVMe SSD instance store helps provide higher throughput for latency-sensitive workloads, providing an alternative to using large RDS for Oracle instances where the workload's resource demand is higher.
- Flash cache is useful for single-block random reads, and it is recommended to size the cache to hold most of an active dataset to reduce input/output costs and increase response time.
- Benefits of placing temporary tablespaces in instance storage include reduced read latency, higher throughput, and less need to provision Input/output operations per second (IOPS). It also frees up space from the RDS instance storage, and temporary files that are not backed up will not be included in RDS instance backups and snapshots.
- You can customize the allocation of the temporary tablespace and the flash cache on the instance store through the RDS parameter group using values from DBInstanceStore with 0-10 in increments of 2.
- Flash cache can be used with Amazon RDS Performance Insights to list DB load sliced by waits and observe top wait events like DB file sequential reads, looking at IOPS and average queue length in Performance Insights and the read latency on Amazon CloudWatch metric.
- Oracle's algorithms partition each buffer into hot or cold areas, with each accessed block moving to the head of the data block chain on the hot side. The instance store can be used to create an additional flash cache that stores hot buffers to improve read input/output and increase response time.
- NVMe SSD local storage for temporary tablespaces showed considerable performance gains in reducing the wait time, with a 61% reduction in SQL execution time for a create table statement that used sorts, joins, and aggregations.
- NVMe SSD local storage for flash cache showed a 94.79% improvement in query performance in TPC-C-like benchmark workloads, cutting down read input/output, and replacing wait events.
- By leveraging RDS for Oracle instances with NVMe SSD storage, you can provide a cost-effective way of facilitating high-throughput in latency-sensitive workloads.
Read Full Article
14 Likes
For uninterrupted reading, download the app