How long does it take to create an RDS for MySQL instance?
The time required to enable the instance varies depending on the instance specification and the current load of the resource pool, with an average time of 5 to 10 minutes.
Among them, the creation time of a read-only instance is related to the data amount of the primary instance. The larger the data amount, the longer the creation time.
Which types of logs occupy the disk space of an RDS for MySQL instance?
File Type | Document Category |
Log files | undo-logs, redo-logs, binlogs, slow logs, and error logs. If the audit function is enabled, there are also audit logs. |
Data files | Database content files and index files. |
Other documents | ibdata, ib_logfile0, temporary files, etc. |
Does the RDS for MySQL instance support scaling down of the disk space?
The RDS for MySQL instance does not support scaling down of the disk space.
You can create a database instance that requires disk space and migrate the database into the new instance through restoration. For details, see Instance Overwriting Restoration in the User Guide.
Which items occupy the storage space of my RDS for MySQL instances?
The items that occupy the storage space of your instance mainly include:
• The data generated during daily use (excluding the backup data, which is stored in separate storage space).
• The disk space has necessary file system overheads, which mainly include inode, reserved block, etc.
• The data required for the operation of an RDS for MySQL instance, such as system databases, database rollback logs, database redo logs, binlog files, indexes, etc.
How much instance disk space is required for DDL operations?
To ensure normal database service, do not perform operations such as DDL (Data Definition Language) during peak hours because these operations may increase disk space sharply. If DDL operations are required, make sure that the disk space is greater than or equal to twice the tablespace size plus 10 GB. For example, If your instance tablespace is 100 GB, make sure that the disk space is greater than or equal to 100 GB × 2 + 10 GB = 210 GB.