[MDEV-8994] Online truncation of InnoDB undo tablespaces Created: 2015-10-22 Updated: 2017-05-29 Resolved: 2017-05-29 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Fix Version/s: | 10.2.2 |
| Type: | Task | Priority: | Minor |
| Reporter: | Leo Kwan | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Fixed | Votes: | 4 |
| Labels: | None | ||
| Description |
|
A new feature that's in mysql 5.7, which is very useful. Especially when we have Galera Cluster enabled, as Galera will copy all files included the undo log tablespaces to a new node. If we can do this house keeping job for the server, we can utilize disk space in a much better way, and have a new node setup much faster. https://dev.mysql.com/doc/refman/5.7/en/truncate-undo-tablespace.html |
| Comments |
| Comment by Marko Mäkelä [ 2017-04-10 ] |
|
leomkkwan, I believe that this should work starting with MariaDB Server 10.2.2 (which merged the InnoDB from MySQL 5.7.9). Can you please confirm this? |