InnoDB engine, when using page compression, heavily depend on file system sparse file support. InnoDB Page Compression.
It raises the question, how will mariabackup/xtrabackup handle those InooDB sparse files in
Suppose we have total of 100G InnoDB tables,(
ls reports 100G but
du reports 0.5G).
The following questions raise:
--backupthis with mariabackup/xtrabackup will the backup itself sparse in the target dir?
--preparethis with mariabackup/xtrabackup will the result is sparse?
--copy-backthis with mariabackup/xtrabackup will the result is sparse
Say mariabackup/xtrabackup does not handle sparse files. (tragedy). Can I correct this behavior with using
cp --sparse=alwaysinstead of
mariabackup --copy-back ...or this is not that simple...