Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ Backup and Restoration Issues/ Manual Backups Taking More Time Than Automated Full Backups
Updated on 2023-03-06 GMT+08:00

Manual Backups Taking More Time Than Automated Full Backups

Scenario

When 20 GB of data needs to be backed up, a full backup automatically performed by RDS takes less time than a full backup performed manually.

Possible Causes

The disk throughput during the manual backup was lower than that during the automated backup.

Check the disk reads and writes on the Cloud Eye console. The following figure is for reference only.

Backups are stored in OBS buckets. The automated backup was performed during off-peak hours of OBS, and therefore took a short period of time. The manual backup was performed during peak hours of OBS, and therefore took much more time.

Solution

Perform full backups during OBS off-peak hours.