Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-339

LP #1043762: Incremental backups may take up to 5x more space after the fix for bug #1022562

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Alexey Kopytov last update 21-09-2012 05:39:35

      Fix for bug #1022562 introduced a regression that may potentially lead to a 5x increase in disk space occupied by incremental backups.

      The problem is that after the fix for bug #1022562 incremental backups take 64 KB more per every table, even if it has not been modified. We have customers with 100,000+ tables (see bug #950334). A simple calculation shows their incremental backups would now take 6+ GB more, even if there have been absolutely no data updates.

      I think the fix should be re-implemented to properly initialize the 1st page when a new tablespace has to be created on prepare. It's quite easy to do, we can reuse the code from fil_create_new_single_table_tablespace().

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: