All Products
Search
Document Center

ApsaraDB for MyBase:Total size of backup files

Last Updated:Jul 14, 2023

This topic describes how to view and manage the total size of backup files for an ApsaraDB MyBase for MySQL instance.

Total size of backup files = Size of data backup files + Size of log backup files

View the total size of backup files

  1. Log on to the ApsaraDB for MyBase console.

  2. In the upper-left corner of the page, 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 total size of backup files.

    Note

    You can perform backups for ApsaraDB MyBase for MySQL instances free of charge. If the system starts to collect the costs of backup storage, you will be 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 page, 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 of the page that appears, click Backup and Restoration. On the page that appears, select 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, find the data backup file that you want to delete, and click Delete in the Actions column.

      Note

      If you cannot find Delete, you can check whether the following requirements are met:

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

      • If the log backup feature is enabled, you can delete only the 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 the data backup files that are retained for more than seven days.

    • Shorten the retention period of data backup files.

      Click the Backup Settings tab. On this tab, click Edit next to Data Backup Settings. In the dialog box that appears, shorten the retention period of data backup files.

      Note

      ApsaraDB for MyBase automatically deletes the data backup files that are retained 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 for MyBase 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 Settings tab. On this tab, click Edit next to Data Backup Settings. In the dialog box that appears, reduce the number of selected days of a week for 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 page, 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 of the page that appears, click Backup and Restoration. On the page that appears, select one of the following methods to reduce the size of log backup files:

    • Shorten the retention period of log backup files.

      Click the Backup Settings tab. On this tab, click Edit next to Local Log Backup Settings. In the dialog box that appears, configure Retention Period to shorten the retention period of log backup files.

      Note

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

    • Disable the log backup feature.

      Click the Backup Settings tab. On this tab, click Edit next to Data Backup Settings. In the dialog box that appears, turn off Log Backup.

      Note

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

    • Reduce unnecessary add, delete, and update operations, especially the update operations on large fields.

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