Reclaim unused space in ibdata1
[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:/
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
- Started by
- Completed by
Whiteboard
It should be possible to skip free pages when copying data files based on the page filtering mechanism introduced in https:/
Work Items
Dependency tree
* Blueprints in grey have been implemented.
