When does old/first oplog entry in the mongo db primary get removed? I could not find much info when that would happen or if it even gets removed as it is a special circular collection.
My assumption would be that, when an oplog entry is synced with all secondaries, it must get removed?
My use case - in a replica set's primary, I perform mongoimport
twice a day, that upserts 290k rows, which causes an oplog window less than 1 hour alert, that auto resolves in few minutes. I wonder if I should increase oplog size - and by how much?
Config:
MongoDB 4.4 Atlas
M10 2GB RAM 10GB Storage
1000 IOPS
1500 max connections
Up to 5 Gigabit network performance