Streaming Replication - wsrep_streaming_log.ibd file keeps increasing

Hi there,
I am using streaming replication in Percona XtraDB Cluster 8.0.27-18.1, wsrep_streaming_log.ibd increased to 3 GB .

  1. What could be the reason for increase of size of the file …?
  2. Can i purge this file …?
  3. How do i manage and optimize this file …?

-rw-r-----. 1 mysql mysql 3.0G Jun 6 16:35 wsrep_streaming_log.ibd

1 Like

InnoDB tables never decrease in size. They only increase, but will re-use existing free space before allocating more. Make sure you are turning off streaming replication once you are finished with it. It should not be enabled globally. If there are no ongoing replication streams, you can simply OPTIMZE this table to reclaim the space manually.

1 Like

@matthewb
Thanks …:slight_smile:

1 Like