ApsaraDB for MyBase:View and manage the size of backup files of an ApsaraDB MyBase for MySQL instance

Size of backup files = Size of data backup files + Size of log backup files.

View the size of backup files

1. Log on to the ApsaraDB for MyBase console.

2. In the upper-left corner of the console, select a region.

3. In the left-side navigation pane, choose Instances > MySQL.

4. Find the instance that you want to manage and click Details in the Actions column.

5. In the lower-right corner of the Basic Information page, view the size of backup files.

   Note

   You can perform backups for ApsaraDB MyBase for MySQL instances free of charge. When the system starts to collect the costs of backup storage, you are notified in advance.

Reduce the size of data backup files

1. Log on to the ApsaraDB for MyBase console.

2. In the upper-left corner of the console, select a region.

3. In the left-side navigation pane, choose Instances > MySQL.

4. Find the instance that you want to manage and click Details in the Actions column.

5. In the left-side navigation pane, click Backup and Restoration. On the page that appears, use one of the following methods to reduce the size of data backup files:

   • Delete one or more data backup files.

     On the Data Backup tab of the Base Backups tab, find the data backup file that you want to delete and click Delete in the Actions column.

     Note

     If the Delete button is dimmed, you can check whether the following requirements are met:

     • If the log backup feature is disabled, you can delete only data backup files that are retained for more than seven days.

     • If the log backup feature is enabled, you can delete only data backup files that are retained for longer than the specified log backup retention period. For example, if you set the log backup retention period to seven days, you can delete data backup files that are retained for more than seven days.

   • Shorten the retention period of data backup files.

     Click the Backup Strategy tab. On the tab, click Edit next to the Basic Backup parameter. In the Basic Backup dialog box, specify a smaller value for the retention period of data backup files.

     Note

     ApsaraDB MyBase for MySQL automatically deletes the data backup files that are stored for longer than the specified data backup retention period. For example, if you set the data backup retention period of your instance to 30 days, ApsaraDB MyBase for MySQL immediately deletes the data backup files that are retained for more than 30 days on your instance.

   • Reduce the data backup frequency.

     Click the Backup Strategy tab. On the tab, click Edit next to the Basic Backup parameter. In the Basic Backup dialog box, decrease the number of selected days of a week for the backup cycle.

Reduce the size of log backup files

1. Log on to the ApsaraDB for MyBase console.

2. In the upper-left corner of the console, select a region.

3. In the left-side navigation pane, choose Instances > MySQL.

4. Find the instance that you want to manage and click Details in the Actions column.

5. In the left-side navigation pane, click Backup and Restoration. On the page that appears, use one of the following methods to reduce the size of log backup files:

   • Shorten the retention period of log backup files.

     Click the Backup Strategy tab. On the tab, click Edit next to the Local Log Retention Policy parameter. In the Local Log Retention Policy dialog box, specify a smaller value for the retention period of log backup files.

     Note

     You can change the log backup retention period only if the log backup feature is enabled.

   • Disable the log backup feature.

     Click the Backup Strategy tab. On the tab, click Edit next to the Basic Backup parameter. In the Basic Backup dialog box, turn off Log Backup.

     Note

     After you disable the log backup feature, ApsaraDB MyBase for MySQL immediately deletes all log backup files. You cannot restore the data of your instance to a specific point in time.

   • Do not perform unnecessary add, delete, and update operations, especially the update operations on large fields.

     Add, delete, and update operations that are performed on databases increase the size of log backup files.