Improve MongoDB indexes #9162
Labels
Comments
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 3, 2023
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 3, 2023
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 3, 2023
mergify bot
pushed a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 3, 2023
https://gravitee.atlassian.net/browse/APIM-2444 gravitee-io/issues#9162 (cherry picked from commit 159cd7b)
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 3, 2023
https://gravitee.atlassian.net/browse/APIM-2444 gravitee-io/issues#9162 (cherry picked from commit 159cd7b)
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 4, 2023
mergify bot
pushed a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 4, 2023
https://gravitee.atlassian.net/browse/APIM-2444 gravitee-io/issues#9162 (cherry picked from commit 58fcc00)
jgiovaresco
added a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 4, 2023
https://gravitee.atlassian.net/browse/APIM-2444 gravitee-io/issues#9162 (cherry picked from commit 58fcc00)
kkibbey1996
pushed a commit
to gravitee-io/gravitee-api-management
that referenced
this issue
Aug 9, 2023
https://gravitee.atlassian.net/browse/APIM-2444 gravitee-io/issues#9162 (cherry picked from commit 159cd7b)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Mongo Atlas Performance Advisor raised warnings about:
Missing indexes:
On 3.19/3.20/4.0
`node_monitoring: { type: 1, updatedAt: 1 }
`
`events: { "properties.dictionary_id":1, "updatedAt" : -1}
`
On 4.0 only
`apis: { "environmentId": 1, "name": 1, "definitionVersion": 1 }
`
`subscriptions: { "updatedAt": 1 }
`
Redundant indexes.
On 3.19/3.20/4.0
events
` { "properties.api_id" : 1 }
`
FYI, an index that is a prefix of another compound index is redundant and can be removed to improve write performance. Since these indexes are prefixes of another compound index, removing them will not affect your read performance.
The text was updated successfully, but these errors were encountered: