Reclaim unused space in ibdata1

Registered by Aleksandr Kuzminsky on 2010-03-22

[FEATURE REQUEST]

Allow me to reclaim unused space in ibdata1 (and/or other global tablespaces). For example, if I convert most (or all) of my innodb tables to file_per_table, I will still have the original (potentially huge) ibdata1.

Yasufumi Kinoshita wrote on 2009-12-17: #1

Hmm.... XtraBackup depends on InnoDB entirely. So, if InnoDB doesn't allow to do so, also XtraBackup doesn't...
It may be feature request to InnoDB engine.

It may need to de-fragmentation of ibdata1 (it contains rollback segment etc...) before shrinking. It may not be so easy.

Yasufumi Kinoshita on 2009-12-17
Changed in percona-xtrabackup:
importance: Undecided → Wishlist

p.s.
Created from the bug https://bugs.launchpad.net/percona-xtrabackup/+bug/463749

Blueprint information

Status:
Not started
Approver:
Vadim Tkachenko
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

It should be possible to skip free pages when copying data files based on the page filtering mechanism introduced in https://blueprints.launchpad.net/percona-xtrabackup/+spec/compact-backups

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.