[MDEV-24170] wsrep_streaming_log file size continues to grow Created: 2020-11-09  Updated: 2021-12-23  Resolved: 2021-12-23

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert, Galera, wsrep
Affects Version/s: 10.5.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Chow King Tak Assignee: Jan Lindström (Inactive)
Resolution: Not a Bug Votes: 1
Labels: grow, wsrep_streaming_log
Environment:

RHEL 7.8
Galera 3-node cluster with 2 DB nodes and 1 arbitrator



 Description   

It is observed that the system table "mysql.wsrep_streaming_log" file size continues to grow when loading a large amount of data. After restarting the DB server, the file size still remains. It needs to optimize the table in order to clean up the file size.

To repeat the scenario:

1. In DB server:
set global wsrep_trx_fragment_size=1073741823;
2. Create a table.
3. Record the table file size of mysql/wsrep_streaming_log.ibd in mydata directory.
4. Load data to the table within a single transaction having total data size <= 1073741823.
5. Record the table file size of mysql/wsrep_streaming_log.ibd again, the size grows accordingly.
6. Restart the DB server, the file size does not decrease.
7. Run optimize the table, the file size decrease.



 Comments   
Comment by Jan Lindström (Inactive) [ 2021-12-23 ]

Unfortunately InnoDB .ibd files sizes newer decrease. You see decrease after restart because table is created again.

Generated at Thu Feb 08 09:27:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.