pt-mongodb-index-check¶
Performs checks on MongoDB indexes.
Checks available¶
Duplicated indexes¶
Check for indexes that are the prefix of other indexes. For example if we have these 2 indexes
db.getSiblingDB("testdb").test_col.createIndex({"f1": 1, "f2": -1, "f3": 1, "f4": 1}, {"name": "idx_01"});
db.getSiblingDB("testdb").test_col.createIndex({"f1": 1, "f2": -1, "f3": 1}, {"name": "idx_02"});
The index idx_02 is the prefix of idx_01 because it has the same
keys in the same order so, idx_02 can be dropped.
Unused indexes.¶
This check gets the $indexstats for all indexes and reports those
having accesses.ops = 0.
Usage¶
Run the program as pt-mongodb-index-check <command> [flags]
Available commands¶
Command |
Description |
|---|---|
check-duplicated |
Run checks for duplicated indexes. |
check-unused |
Run check for unused indexes. |
check-all |
Run all checks |
Available flags¶
Flag |
Description |
|---|---|
–all-databases |
Check in all databases excluding system dbs. |
–databases=DATABASES,… |
Comma separated list of databases to check. |
–all-collections |
Check in all collections in the selected databases. |
–collections=COLLECTIONS,… |
Comma separated list of collections to check. |
–mongodb.uri= |
Connection URI |
–json |
Show output as JSON |
–version |
Show version information |