Oracle Cloud Infrastructure Documentation

DB System Storage

The storage performance of MySQL HeatWave Service scales with the storage size allocated to the DB system. You can manually increase the storage size of your DB system when required or enable automatic storage expansion to allow the storage size to expand automatically on demand.

You cannot limit or edit the IOPS of the storage. You must provision the storage size based on your data size and performance requirements.

MySQL HeatWave Service uses the Block Volume service Higher Performance option over iSCSI. The final performance results may vary for different shapes and scenarios. It is recommended to perform benchmark analysis during your Proof of Concept testing to verify your environment configuration has adequate performance for your application requirements.

The Higher Performance Block Volume provides a linear performance scale of 75 IOPS/GiB up to a maximum of 50,000 IOPS per volume. Throughput scales at the rate 600 KiB/s/GiB up to a maximum of 680 MiB/s per volume.
Note

The storage throughput can also be limited by the maximum network bandwidth of the DB system's shape.
DB systems stripe the data across multiple volumes to achieve higher performance and larger storage size. The number of volumes is determined by the initial storage size specified during the DB system creation and does not change over the lifetime of the DB system. Restoring a DB system from a backup also retains the number of volumes of the original DB system even if you increase the storage size significantly during the restore.
Note

If you create a DB system with a small initial storage size and increase the storage size multiple times larger later, the storage performance could be limited by the less than optimal number of volumes.

The storage size of a DB system can be increased manually or automatically. See Increasing the Storage of a DB System and Enabling or Disabling Automatic Storage Expansion. Increasing the storage size does not increase the number of volumes allocated to the DB system during its creation. Whenever the storage size is increased, the billing for storage usage will increase accordingly.