Cleanup MongoDB Log

Creation date: 17/10/2022 12:04 Updated: 17/10/2022 12:04 #mongodbforlog

Question:

Hi CSO,

We encounter many high latencies around ~50s in Datahub B2C Production.

Can you check on this?

What is happening, since it is not the first time and we did upgrade the machine & revisit the indexing.

Answer:

Investigation:

After the archive on DocumentDB, we have improved 2 more slow queries... this has reduced from 50s to 20s to 10s.

Customer is ok to close the ticket.

Investigation:

The DocumentDB has grown very big. Ask customer to archive and detele.

All these tables except TC_MONITOR_RECEIVE_HEADER and SQL_LOD_A30 and delete by adddate (maybe retention data of a week)

Contents