If I visit MongoDB Atlas Profiler, I can observe on each and every day a similar pattern of slow queries. It looks like this:
If ordered by Mean or Sum of operation execution time, the top 30 or more are collections with suffix
_gtins_catalog that are empty, created when the user is creating an account.
Now, when I am investigating the queries for any of these collections they are usually several of them
and all of them have pipeline like this:
And the Operation Execution Time can even reach up to 2 min.
And now is my question. I can’t figure out what cause this pipelines to be executed, especially on empty collections, and why they are this slow. Is this some internal operations that Mongo have to perform?
It would be very helpful If someone could cast a bit of light on this.
Thanks for being a part of MongoDB’s developer community! I’d like to take a closer look and see what may be causing this rogue command. At first glance, this does not look like an internal operation that MongoDB is running.
If you can click on one of the commands and investigate the query details, you should be able to see the “appName” that is calling this command. Would you mind checking on this and sharing what you find?
Thank you for the reply, this is what you’ve asked for:
"appName": "mongot steady state"
Edit: Now as it came to my mind I probably should have mentioned, that even it these collections are empty, they have an Atlas Search Index created on them.
Hey @Grzegorz_Skupiewski - PM from Atlas Search here - can you share what cluster tier you are on?
Hi @Elle_Shwer, it is
I see, any chance you have a support package where you can submit a ticket about this?
Unfortunately, that is not an option for us. Any suspicions what might be a cause or hints where to look further?
Without much more info, the only interpretation I heard was: The query itself looks like the changestream mongot/AtlasSearch follows for steady state replication. It is possible for changestream queries to be slow on a collection without any writes due to writes on neighboring collections. But there is no precedent for this / it’s not something we’ve seen before. It’s hard to know beyond that.