Ygthkb

Is the percentage symbol a constant?

How can I keep my gold safe from other PCs?

Why can't i set the 'prototype' of a function created using 'bind'?

Missing space after parenthesis in inline text

What does an unprocessed RAW file look like?

Existence of a strange function

What really causes series inductance of capacitors?

Minimum Viable Product for RTS game?

Problems with position of tikzpictures in beamer

What is an efficient way to digitize a family photo collection?

In a post apocalypse world, with no power and few survivors, would Satnav still work?

Why does a single AND gate need 60 transistors?

Linearity Assumption

1990s-2000s horror alien movie with slugs infecting people through the mouth

Do the speed limit reductions due to pollution also apply to electric cars in France?

Coworker asking me to not bring cakes due to self control issue. What should I do?

What is the principle behind "circuit total limitation" (CTL) for electrical panels?

Inline Feynman diagrams, Feynman diagrams in equations, very small Feynman diagrams

Why don't you get burned by the wood benches in a sauna?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

Is Screenshot Time-tracking Common?

Boss asked me to sign a resignation paper without a date on it along with my new contract

Neglect higher order derivatives in expression

Is layered encryption more secure than long passwords?

How to match a WiredTiger index file to its corresponding collection

MongoDB performance limits of mongoScaling out mongodb on the same storageAdding a Mongo Shard decreases the insert performanceMake MongoDB close open filesIs using the MongoDB _id field index as a time range query possible?MongoDB sharded cluster chunks distributionReliability of mongodumpUnstructured point cloud data from MongoDB vs filesystemPartially rotating MongoDB collection efficiencymongo-hadoop connector makes duplicate data by numbers of Mongo Sharding

3

I have a mongodb database with about 2 billion records, shared between 20 or so collections. Each of these collections has an index on it, based on a single key (other than _id).

I have an index file (named index-1-5374774422504609475.wt) that I'd like to match to a collection. Is there a quick way to match directly which index file corresponds to a collection?

I do mean the actual physical index file in the mongo db directory.

Thanks in advance!

mongodb mongo-repair

share|improve this question

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

add a comment | 

3

I have a mongodb database with about 2 billion records, shared between 20 or so collections. Each of these collections has an index on it, based on a single key (other than _id).

I have an index file (named index-1-5374774422504609475.wt) that I'd like to match to a collection. Is there a quick way to match directly which index file corresponds to a collection?

I do mean the actual physical index file in the mongo db directory.

Thanks in advance!

mongodb mongo-repair

share|improve this question

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

add a comment | 

I have a mongodb database with about 2 billion records, shared between 20 or so collections. Each of these collections has an index on it, based on a single key (other than _id).

I have an index file (named index-1-5374774422504609475.wt) that I'd like to match to a collection. Is there a quick way to match directly which index file corresponds to a collection?

I do mean the actual physical index file in the mongo db directory.

Thanks in advance!

mongodb mongo-repair

share|improve this question

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

share|improve this question

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

share|improve this question

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

asked Jul 31 '17 at 21:36

JonLucaJonLuca

1207

1 Answer
1

active

oldest

votes

3

Ref:
https://docs.mongodb.com/manual/reference/method/db.collection.stats/

https://docs.mongodb.com/manual/reference/command/collStats/#collStats.indexDetails

As you are using WiredTiger storage engine you can use db.collection.stats() with indexDetails option set to true.

Easy copy paste:

.stats({"indexDetails":true})

A document that reports data from the WiredTiger storage engine for
each index in the collection. Other storage engines will return an
empty document.

The fields in this document are the names of the indexes, while the
values themselves are documents that contain statistics for the index
provided by the storage engine. These statistics are for internal
diagnostic use.

share|improve this answer

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Exactly what I was looking for. Should've RTFM, thanks!
  
  – JonLuca
  Aug 1 '17 at 1:42
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f182298%2fhow-to-match-a-wiredtiger-index-file-to-its-corresponding-collection%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

Ref:
https://docs.mongodb.com/manual/reference/method/db.collection.stats/

https://docs.mongodb.com/manual/reference/command/collStats/#collStats.indexDetails

As you are using WiredTiger storage engine you can use db.collection.stats() with indexDetails option set to true.

Easy copy paste:

.stats({"indexDetails":true})

A document that reports data from the WiredTiger storage engine for
each index in the collection. Other storage engines will return an
empty document.

The fields in this document are the names of the indexes, while the
values themselves are documents that contain statistics for the index
provided by the storage engine. These statistics are for internal
diagnostic use.

share|improve this answer

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Exactly what I was looking for. Should've RTFM, thanks!
  
  – JonLuca
  Aug 1 '17 at 1:42
  

  
  
  
  

add a comment | 

3

Ref:
https://docs.mongodb.com/manual/reference/method/db.collection.stats/

https://docs.mongodb.com/manual/reference/command/collStats/#collStats.indexDetails

As you are using WiredTiger storage engine you can use db.collection.stats() with indexDetails option set to true.

Easy copy paste:

.stats({"indexDetails":true})

A document that reports data from the WiredTiger storage engine for
each index in the collection. Other storage engines will return an
empty document.

The fields in this document are the names of the indexes, while the
values themselves are documents that contain statistics for the index
provided by the storage engine. These statistics are for internal
diagnostic use.

share|improve this answer

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Exactly what I was looking for. Should've RTFM, thanks!
  
  – JonLuca
  Aug 1 '17 at 1:42
  

  
  
  
  

add a comment | 

Ref:
https://docs.mongodb.com/manual/reference/method/db.collection.stats/

https://docs.mongodb.com/manual/reference/command/collStats/#collStats.indexDetails

As you are using WiredTiger storage engine you can use db.collection.stats() with indexDetails option set to true.

Easy copy paste:

.stats({"indexDetails":true})

A document that reports data from the WiredTiger storage engine for
each index in the collection. Other storage engines will return an
empty document.

The fields in this document are the names of the indexes, while the
values themselves are documents that contain statistics for the index
provided by the storage engine. These statistics are for internal
diagnostic use.

share|improve this answer

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

share|improve this answer

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

edited 11 mins ago

JonLuca

1207

edited 11 mins ago

JonLuca

1207

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335

answered Aug 1 '17 at 1:14

SqlWorldWideSqlWorldWide

8,20021335