[MDEV-32622] [mariadb-galera] The undo log is very large, how can there be fewer undo log logs Created: 2023-10-30  Updated: 2023-10-31

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.6.8
Fix Version/s: None

Type: Bug Priority: Major
Reporter: luorui Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None
Environment:

os：centos7 arch： amd64

Attachments: PNG File image-2023-10-30-18-30-25-338.png     PNG File image-2023-10-30-18-30-39-823.png    
Issue Links:
Relates
relates to MDEV-14795 InnoDB system tablespace cannot be sh... Closed
relates to MDEV-32050 UNDO logs still growing for write-int... Closed
relates to MDEV-32629 【mariadb-galera】 I have three nodes, ... Closed

 Description   



Question 1：The undo log is very large, how can there be fewer undo log logs
Question 2：【mariadb-galera】 I have three nodes, but only one node, ibdata1, is very large, what is the reason for this?

 Comments   
Comment by Marko Mäkelä [ 2023-10-30 ]

The InnoDB purge of committed transaction history was reworked in MDEV-32050. I would recommend to upgrade to 10.6.16 as soon as it is released.

Unfortunately, the InnoDB system tablespace cannot be shrunk in this version. MDEV-14795 was implemented in MariaDB Server 11.2.

Comment by luorui [ 2023-10-30 ]

Thanks, but I'm using mariadb-galera with only one node ibdata1 will be like this, is this normal @Marko Mäkelä

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