Hello. I was trying to find jumbo chunks in our database and was purely depending on the output of the sh.status("true")
command to find that. But unfortunately, setting the verbose flag to true doesn’t print all the chunks of a given collection, so couldn’t find a jumbo chunk
Then, later found a jumbo by querying the config.chunks collection as mentioned in this percona blog post. Now, the chunk doc doesn’t mention which collection this jumbo chunk belongs to nor how many documents are in this chunk nor its size. The key mentioned in the min/max is present in multiple collections of our database, so it is not possible to narrow down
how can I drill down further? Please let me know if you need more info
[direct: mongos] config> db.chunks.find({"jumbo":true} )
[
{
_id: ObjectId("63a5537d7c71b9f73c26d76a"),
uuid: new UUID("b8d18a69-1f62-4370-98ee-9e2c349f8c2f"),
min: {
'value.id': Long("-3006967400825036684")
},
max: {
'value.id': Long("-3006947767359106207")
},
shard: 'mongos-01-shard-02',
lastmod: Timestamp({ t: 89, i: 1 }),
jumbo: true,
history: [
{
validAfter: Timestamp({ t: 1671689810, i: 6 }),
shard: 'mongos-01-shard-02'
}
]
}
]