Disclaimer
The views expressed on this blog are my own and do not
necessarily reflect the views of Oracle.
Introduction
There are database usage patterns, where tables grow big at times
and many rows are deleted from them later. InnoDB does never
shrink a table space. In these cases we can end up with big data
files, which contain a lot of unused pages. It is a waste of
disk- and I/O- resources to back them up.
Users have manifold requested that MySQL Enterprise Backup does
not back up unused InnoDB data pages. Some want smaller backups,
some want less I/O, some want shrinked table spaces.
MySQL Enterprise Backup 3.9.0 can help with smaller backups. The
effect on I/O is not that remarkable. InnoDB data files must be
expanded to their original size when they are restored. Backup
cannot accomplish a shrinkage of InnoDB table spaces.
In the following I will try to explain, how …
Showing entries 1 to 1
Sep
18
2013
Showing entries 1 to 1