[MDEV-17555] Allow moving UNDO segments into separate UNDO tablespaces without total rebuild of the data directory from a logical backup Created: 2018-10-26  Updated: 2019-12-10

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Ulrich Moser (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

On servers with bursts of data changes the system table space tends to grow due to UNDO segments stored there and cannot be shrinked again. The current workaround is to take a logical backup, reinitialize the data directory with previously configuring separate UNDO tablespaces and reload the data from the mysqldump file. For large databases it should be possible to move UNDO segments out of the system table space without rebuilding the whole data directory. This process is unacceptable due the long downtimes caused by exporting and re-importing the data.
In new installations UNDO tablespaces should be default.


Generated at Thu Feb 08 08:37:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.