I have a dev env database with a collection size of 2.5 Billion records. The are 5 existing regular indexes. I am trying to create a new compound index with 2 fields using the Mongo Compass tool.
I have tried with more than 5 times and it’s failing. Each time it takes more than 8 hours and fails. How can I debug it? Where can I find the error logs?
I am new MongoDb so please let me know what else info I can provide. appreciate the help.
Other existing 5 indexes size:
_id: 100.4 GB
index_1: 78 GB
index:_2: 100.4 GB
index_3: 78 GB
index_4: 95.8 GB