Skip to content

Instantly share code, notes, and snippets.

View karan9's full-sized avatar
🏠
Working from home

Karan Srivastava karan9

🏠
Working from home
View GitHub Profile
var colls = db.getCollectionNames();
var ret = [];
colls.forEach(function(coll) {
if (String(coll).startsWith("system")) {
return;
}
var indexes = db.getCollection(coll).getIndexes();
var stats = db.getCollection(coll).aggregate( [ { $indexStats: { } } ] );
var colls = db.getCollectionNames();
var ret = [];
colls.forEach(function(coll) {
if (String(coll).startsWith("system")) {
return;
}
var indexes = db.getCollection(coll).getIndexes();
var stats = db.getCollection(coll).aggregate( [ { $indexStats: { } } ] ).toArray();
@karan9
karan9 / formatLogFile.js
Last active December 1, 2020 19:43
Simple MongoDB Log Fixer For People who use windowwwwzzzz
const rl = require("readline");
const FILEPATH = "/Users/Karan.Srivastava/Desktop/Manish Sahni/s1.log";
const OUTPUTFILE = "s1k.log";
const lineReader = rl.createInterface({
input: require("fs").createReadStream(require("path").normalize(FILEPATH))
})
let prevLine = "";
const { ClientEncryption } = require('mongodb-client-encryption');
const base64 = require('uuid-base64');
const mongoose = require('mongoose');
// DONOT USE IN PRODUCTION
function getEncryptionKey() {
const arr = [];
for (let i = 0; i < 96; ++i) {
arr.push(i);
}
const MongoClient = require("mongodb").MongoClient;
const util = require('util')
const MONGOURI = "MONGOURL";
const DB = "lever-hire-nurture";
const COLL = "profiles";
const client = new MongoClient(MONGOURI, { useNewUrlParser: true, useUnifiedTopology: true });
client.connect(err => {
@karan9
karan9 / updatedKeyhole.js
Last active February 16, 2021 03:37
Updated Version of Keyhole Script to get rid to index summary errors ..
// Copyright 2020 Kuei-chun Chen. All rights reserved.
var cluster = GetClustersSummary()
var data = JSON.stringify(cluster);
print(data);
function GetClustersSummary() {
var cluster = { "cluster": "standalone", "databases": [],
"keyhole": { "version": "v2.5.0-js", "collected": new Date(), "logs": [] } };
cluster["keyhole"]["logs"].push(new Date().toISOString()+" keyhole.js began");
var doc = db.serverStatus();
@karan9
karan9 / zstd.js
Created June 29, 2021 04:54
Create a collection with zstd compression
// Create a ZSTD Collection
db.createCollection("COLLNAME", {storageEngine: {wiredTiger: {configString: "block_compressor=zstd"}}})
// Check which block compressor is being used for a collection
var wt_options = db.zlogs.stats().wiredTiger.creationString.split(',')
// filter the options
wt_options.filter((wt_options) => wt_options.startsWith('block_compressor'))