Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TTL indexes are shown as unused #73

Closed
kagahd opened this issue Sep 1, 2021 · 3 comments
Closed

TTL indexes are shown as unused #73

kagahd opened this issue Sep 1, 2021 · 3 comments

Comments

@kagahd
Copy link

kagahd commented Sep 1, 2021

According to mongoDB's documention, the statistics [reported by the $indexStats aggregation] only includes index access driven by user requests. It does not include internal operations like deletion via TTL Indexes or chunk split and migration operations.
See also: https://jira.mongodb.org/browse/SERVER-21815
Therefore, in Maobi, in section 1.1.5 Unused Indexes (mongod up > 7 days), you may see "unused" indexes which in fact may be TTL indexes and as such are not unused.
Suggestion: Maobi should take into account TTL indexes and not show or count them as "unused".

@simagix
Copy link
Owner

simagix commented Sep 3, 2021

corrected in Maobi and pushed. thank you

@simagix simagix closed this as completed Sep 3, 2021
@kagahd
Copy link
Author

kagahd commented Sep 9, 2021

Thanks @simagix for the fix!
Could you point me to the code that you have changed to fix it please?

@simagix
Copy link
Owner

simagix commented Sep 13, 2021

maobi is a private repo

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants