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