I am using streaming replication in
Percona XtraDB Cluster 8.0.27-18.1, wsrep_streaming_log.ibd increased to 3 GB .
- What could be the reason for increase of size of the file …?
- Can i purge this file …?
- How do i manage and optimize this file …?
-rw-r-----. 1 mysql mysql 3.0G Jun 6 16:35 wsrep_streaming_log.ibd
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.