[MDEV-31760] innodb_undo_tablespaces would be better default >= 2 Created: 2023-07-21  Updated: 2023-07-22  Resolved: 2023-07-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: None
Fix Version/s: 11.0.1

Type: Bug Priority: Minor
Reporter: Fan Lyu Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-29986 Set innodb_undo_tablespaces=3 by default Closed

 Description   

innodb_undo_tablespaces is default 0. which makes undolog shares ibdata file.
This may lead to no truncating because undologs are not independent files.
And this will cause very big ibdata1 file size, occupying much disk capacity.

And this variable can only be changed by initialization, which is kind of inconvenient.
would it be better to set it as default 2?

 Comments   
Comment by Marko Mäkelä [ 2023-07-22 ]

In fact, this has already been done in MDEV-29986.

Generated at Thu Feb 08 10:26:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.