shutdownServer()
This method shuts down the current mongod or mongos process cleanly and safely.
Syntax:
db.shutdownServer()
Example 1: When the database is not an admin database.
use products
MongoDB
db.shutdownServer()
Output
shutdown command only works with the admin database; try 'use admin'
Example 2: When the database is an admin database.
use admin
MongoDB
db.shutdownServer()
Output
server should be down...
setLogLevel(level, component?)
This method sets a single verbosity level for log messages.
Omit the <component> parameter to set the default verbosity for all components; i.e. the systemLog.verbosity setting. The operation sets the default verbosity to 1:
Syntax:
db.setLogLevel(level, component?)
Example
MongoDB
db.setLogLevel(1)
Output:
{"was" : {"verbosity" : 0,"accessControl" : {"verbosity" : -1},"command" : {"verbosity" : -1},"control" : {"verbosity" : -1},"executor" : {"verbosity" : -1},"geo" : {"verbosity" : -1},"index" : {"verbosity" : -1},"network" : {"verbosity" : -1,"asio" : {"verbosity" : -1},"bridge" : {"verbosity" : -1},"connectionPool" : {"verbosity" : -1}},"query" : {"verbosity" : -1},"replication" : {"verbosity" : -1,"election" : {"verbosity" : -1},"heartbeats" : {"verbosity" : -1},"initialSync" : {"verbosity" : -1},"rollback" : {"verbosity" : -1}},"sharding" : {"verbosity" : -1,"rangeDeleter" : {"verbosity" : -1},"shardingCatalogRefresh" : {"verbosity" : -1},"migration" : {"verbosity" : -1},"reshard" : {"verbosity" : -1},"migrationPerf" : {"verbosity" : -1}},"storage" : {"verbosity" : -1,"recovery" : {"verbosity" : -1},"journal" : {"verbosity" : -1}},"write" : {"verbosity" : -1},"ftdc" : {"verbosity" : -1},"tracking" : {"verbosity" : -1},"transaction" : {"verbosity" : -1},"tenantMigration" : {"verbosity" : -1},"test" : {"verbosity" : -1}},"ok" : 1}
setProfilingLevel(level, slowms?)
This method modifies the current database profiler level used by the database profiling system to capture data about performance.
Syntax:
db.setProfilingLevel(level, slowms?)
Example 1
MongoDB
db.setProfilingLevel(1)
Output
{ "was" : 0, "slowms" : 100, "sampleRate" : 1, "ok" : 1 }
Example 2
MongoDB
db.setProfilingLevel(2)
Output
{ "was" : 1, "slowms" : 100, "sampleRate" : 1, "ok" : 1 }
serverBuildInfo()
This method provides a wrapper around the buildInfo database command. buildInfo returns a document that contains an overview of parameters used to compile this mongod instance.
Syntax:
db.serverBuildInfo()
Example
MongoDB
db.serverBuildInfo()
Output:
{"version" : "5.0.6","gitVersion" : "212a8dbb47f07427dae194a9c75baec1d81d9259","targetMinOS" : "Windows 7/Windows Server 2008 R2","modules" : [ ],"allocator" : "tcmalloc","javascriptEngine" : "mozjs","sysInfo" : "deprecated","versionArray" : [5,0,6,0],"openssl" : {"running" : "Windows SChannel"},"buildEnvironment" : {"distmod" : "windows","distarch" : "x86_64","cc" : "cl: Microsoft (R) C/C++ Optimizing Compiler Version 19.29.30139 for x64","ccflags" : "/nologo /WX /FImongo/platform/basic.h /EHsc /W3 /wd4068 /wd4244 /wd4267 /wd4290 /wd4351 /wd4355 /wd4373 /wd4800 /wd4251 /wd4291 /we4013 /we4099 /we4930 /errorReport:none /MD /O2 /Oy- /bigobj /utf-8 /permissive- /Zc:__cplusplus /Zc:sizedDealloc /volatile:iso /diagnostics:caret /std:c++17 /Gw /Gy /Zc:inline","cxx" : "cl: Microsoft (R) C/C++ Optimizing Compiler Version 19.29.30139 for x64","cxxflags" : "/TP","linkflags" : "/nologo /DEBUG /INCREMENTAL:NO /LARGEADDRESSAWARE /OPT:REF","target_arch" : "x86_64","target_os" : "windows","cppdefines" : "SAFEINT_USE_INTRINSICS 0 PCRE_STATIC NDEBUG BOOST_ALL_NO_LIB _UNICODE UNICODE _SILENCE_CXX17_ALLOCATOR_VOID_DEPRECATION_WARNING _SILENCE_CXX17_OLD_ALLOCATOR_MEMBERS_DEPRECATION_WARNING _SILENCE_CXX17_CODECVT_HEADER_DEPRECATION_WARNING _CONSOLE _CRT_SECURE_NO_WARNINGS _SCL_SECURE_NO_WARNINGS _WIN32_WINNT 0x0A00 BOOST_USE_WINAPI_VERSION 0x0A00 NTDDI_VERSION 0x0A000000 BOOST_THREAD_VERSION 5 BOOST_THREAD_USES_DATETIME BOOST_SYSTEM_NO_DEPRECATED BOOST_MATH_NO_LONG_DOUBLE_MATH_FUNCTIONS BOOST_ENABLE_ASSERT_DEBUG_HANDLER BOOST_LOG_NO_SHORTHAND_NAMES BOOST_LOG_USE_NATIVE_SYSLOG BOOST_LOG_WITHOUT_THREAD_ATTR ABSL_FORCE_ALIGNED_ACCESS"},"bits" : 64,"debug" : false,"maxBsonObjectSize" : 16777216,"storageEngines" : ["devnull","ephemeralForTest","wiredTiger"],"ok" : 1}
serverStatus(options?)
This method returns a document that provides an overview of the database process’s state.
Syntax:
db.serverStatus(options?)
Example
MongoDB
db.serverStatus()
Output
{"host" : "DESKTOP-MP73JVQ","version" : "5.0.6","process" : "C:\\Program Files\\MongoDB\\Server\\5.0\\bin\\mongod.exe","pid" : NumberLong(4092),"uptime" : 182939,"uptimeMillis" : NumberLong(182938923),"uptimeEstimate" : NumberLong(182938),"localTime" : ISODate("2022-07-19T15:34:29.928Z"),"asserts" : {"regular" : 0,"warning" : 0,"msg" : 0,"user" : 28,"tripwire" : 0,"rollovers" : 0},"catalogStats" : {"collections" : 2,"capped" : 0,"timeseries" : 0,"views" : 0,"internalCollections" : 6,"internalViews" : 0},"connections" : {"current" : 1,"available" : 999999,"totalCreated" : 3,"active" : 1,"threaded" : 1,"exhaustIsMaster" : 0,"exhaustHello" : 0,"awaitingTopologyChanges" : 0},"electionMetrics" : {"stepUpCmd" : {"called" : NumberLong(0),"successful" : NumberLong(0)},"priorityTakeover" : {"called" : NumberLong(0),"successful" : NumberLong(0)},"catchUpTakeover" : {"called" : NumberLong(0),"successful" : NumberLong(0)},"electionTimeout" : {"called" : NumberLong(0),"successful" : NumberLong(0)},"freezeTimeout" : {"called" : NumberLong(0),"successful" : NumberLong(0)},"numStepDownsCausedByHigherTerm" : NumberLong(0),"numCatchUps" : NumberLong(0),"numCatchUpsSucceeded" : NumberLong(0),"numCatchUpsAlreadyCaughtUp" : NumberLong(0),"numCatchUpsSkipped" : NumberLong(0),"numCatchUpsTimedOut" : NumberLong(0),"numCatchUpsFailedWithError" : NumberLong(0),"numCatchUpsFailedWithNewTerm" : NumberLong(0),"numCatchUpsFailedWithReplSetAbortPrimaryCatchUpCmd" : NumberLong(0),"averageCatchUpOps" : 0},"extra_info" : {"note" : "fields vary by platform","page_faults" : 92210,"usagePageFileMB" : 244,"totalPageFileMB" : 9206,"availPageFileMB" : 2883,"ramMB" : 5878},"flowControl" : {"enabled" : true,"targetRateLimit" : 1000000000,"timeAcquiringMicros" : NumberLong(1705),"locksPerKiloOp" : 0,"sustainerRate" : 0,"isLagged" : false,"isLaggedCount" : 0,"isLaggedTimeMicros" : NumberLong(0)},"freeMonitoring" : {"state" : "undecided"},"globalLock" : {"totalTime" : NumberLong("182939984000"),"currentQueue" : {"total" : 0,"readers" : 0,"writers" : 0},"activeClients" : {"total" : 0,"readers" : 0,"writers" : 0}},"locks" : {"ParallelBatchWriterMode" : {"acquireCount" : {"r" : NumberLong(277)}},"ReplicationStateTransition" : {"acquireCount" : {"w" : NumberLong(61652)}},"Global" : {"acquireCount" : {"r" : NumberLong(61537),"w" : NumberLong(268),"W" : NumberLong(5)}},"Database" : {"acquireCount" : {"r" : NumberLong(8),"w" : NumberLong(267),"R" : NumberLong(1),"W" : NumberLong(1)}},"Collection" : {"acquireCount" : {"r" : NumberLong(12),"w" : NumberLong(265),"W" : NumberLong(2)}},................................................................................................................
db.serverBits(): This method returns the server bits either 64 or 32.
Note:
If you have installed 32-bit then it will return 32, and if you have installed 64-bit then it will return 64.
Syntax:
db.serverBits()
Example 1: For 64-bit.
MongoDB
db.serverBits()
Output
64
Example 2: For 32-bit.
MongoDB
db.serverBits()
Output
32
db.printShardingStatus(verbose?)
This method prints a formatted report of the sharding configuration and the information regarding existing chunks in a sharded cluster.
Syntax:
db.printShardingStatus()
Example
MongoDB
db.printShardingStatus()
Output:
printShardingStatus: this db does not have sharding enabled. be sure you are connecting to a mongos from the shell and not to a mongod.
db.printSecondaryReplicationInfo()
This method prints a formatted report of the replica set member’s oplog.
Syntax:
db.printSecondaryReplicationInfo()
Example
MongoDB
db.printSecondaryReplicationInfo()
Output:
source: localhost:27001syncedTo: Wed July 06 2022 16:30:50 GMT-08000 secs (0 hrs) behind the primarysource: localhost:27002syncedTo: Wed July 06 2022 16:30:50 GMT-08000 secs (0 hrs) behind the primary
printReplicationInfo()
This method prints a formatted report of the replica set member’s oplog.
Syntax:
db.printReplicationInfo()
Example 1: When replica information not detected
MongoDB
db.printReplicationInfo()
Output
{ "errmsg" : "replication not detected" }
Example 2: When replica information is detected
MongoDB
db.printReplicationInfo()
Output:
configured oplog size: 192MBlog length start to end: 65422secs (12.05hrs)oplog first event time: Wed July 06 2022 17:47:18 GMT-0400 (EDT)oplog last event time: Wed July 06 2022 11:57:40 GMT-0400 (EDT)now: Thu July 07 2022 14:24:39 GMT-0400 (EDT)
printCollectionStats()
This method provides a wrapper around the db.collection.stats() method. This method returns statistics from every collection separated by three hyphen characters.
Syntax:
db.printCollectionStats()
Example
use local
db.printCollectionStats()
MongoDB
db.printCollectionStats()
Output:
startup_log{"ns" : "local.startup_log","size" : 36128,"count" : 16,"avgObjSize" : 2258,"storageSize" : 36864,"freeStorageSize" : 16384,"capped" : true,"max" : 0,"maxSize" : 10485760,"wiredTiger" : {"metadata" : {"formatVersion" : 1},"creationString" : "access_pattern_hint=none,allocation_size=4KB,app_metadata=(formatVersion=1),assert=(commit_timestamp=none,durable_timestamp=none,read_timestamp=none,write_timestamp=off),block_allocation=best,block_compressor=snappy,cache_resident=false,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=false,extractor=,format=btree,huffman_key=,huffman_value=,ignore_in_memory_cache_size=false,immutable=false,import=(enabled=false,file_metadata=,repair=false),internal_item_max=0,internal_key_max=0,internal_key_truncate=true,internal_page_max=4KB,key_format=q,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=true),lsm=(auto_throttle=true,bloom=true,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=false,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_custom=(prefix=,start_generation=0,suffix=),merge_max=15,merge_min=0),memory_page_image_max=0,memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=false,prefix_compression_min=4,readonly=false,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,tiered_object=false,tiered_storage=(auth_token=,bucket=,bucket_prefix=,cache_directory=,local_retention=300,name=,object_target_size=10M),type=file,value_format=u,verbose=[],write_timestamp_usage=none","type" : "file","uri" : "statistics:table:collection-2-2850471386552224837","LSM" : {"bloom filter false positives" : 0,"bloom filter hits" : 0,"bloom filter misses" : 0,"bloom filter pages evicted from cache" : 0,"bloom filter pages read into cache" : 0,"bloom filters in the LSM tree" : 0,"chunks in the LSM tree" : 0,"highest merge generation in the LSM tree" : 0,"queries that could have benefited from a Bloom filter that did not exist" : 0,"sleep for LSM checkpoint throttle" : 0,"sleep for LSM merge throttle" : 0,"total size of bloom filters" : 0},"block-manager" : {"allocations requiring file extension" : 2,"blocks allocated" : 4,"blocks freed" : 1,"checkpoint size" : 4096,"file allocation unit size" : 4096,"file bytes available for reuse" : 16384,"file magic number" : 120897,"file major version number" : 1,"file size in bytes" : 36864,"minor version number" : 0},"btree" : {"btree checkpoint generation" : 2287,"btree clean tree checkpoint expiration time" : NumberLong("9223372036854775807"),"btree compact pages reviewed" : 0,"btree compact pages rewritten" : 0,"btree compact pages skipped" : 0,"btree skipped by compaction as process would not reduce size" : 0,"column-store fixed-size leaf pages" : 0,"column-store internal pages" : 0,"column-store variable-size RLE encoded values" : 0,"column-store variable-size deleted values" : 0,"column-store variable-size leaf pages" : 0,"fixed-record size" : 0,"maximum internal page size" : 4096,"maximum leaf page key size" : 2867,"maximum leaf page size" : 32768,"maximum leaf page value size" : 67108864,"maximum tree depth" : 3,"number of key/value pairs" : 0,"overflow pages" : 0,"row-store empty values" : 0,"row-store internal pages" : 0,"row-store leaf pages" : 0},"cache" : {"bytes currently in the cache" : 40571,"bytes dirty in the cache cumulative" : 40571,"bytes read into cache" : 34037,"bytes written from cache" : 36300,"checkpoint blocked page eviction" : 0,"checkpoint of history store file blocked non-history store page eviction" : 0,"data source pages selected for eviction unable to be evicted" : 0,"eviction gave up due to detecting an out of order on disk value behind the last update on the chain" : 0,"eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update" : 0,"eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update after validating the update chain" : 0,"eviction gave up due to detecting out of order timestamps on the update chain after the selected on disk update" : 0,"eviction walk passes of a file" : 0,"eviction walk target pages histogram - 0-9" : 0,"eviction walk target pages histogram - 10-31" : 0,"eviction walk target pages histogram - 128 and higher" : 0,"eviction walk target pages histogram - 32-63" : 0,"eviction walk target pages histogram - 64-128" : 0,"eviction walk target pages reduced due to history store cache pressure" : 0,"eviction walks abandoned" : 0,"eviction walks gave up because they restarted their walk twice" : 0,"eviction walks gave up because they saw too many pages and found no candidates" : 0,"eviction walks gave up because they saw too many pages and found too few candidates" : 0,"eviction walks reached end of tree" : 0,"eviction walks restarted" : 0,"eviction walks started from root of tree" : 0,"eviction walks started from saved location in tree" : 0,"hazard pointer blocked page eviction" : 0,"history store table insert calls" : 0,"history store table insert calls that returned restart" : 0,"history store table out-of-order resolved updates that lose their durable timestamp" : 0,"history store table out-of-order updates that were fixed up by reinserting with the fixed timestamp" : 0,"history store table reads" : 0,"history store table reads missed" : 0,"history store table reads requiring squashed modifies" : 0,"history store table truncation by rollback to stable to remove an unstable update" : 0,"history store table truncation by rollback to stable to remove an update" : 0,"history store table truncation to remove an update" : 0,"history store table truncation to remove range of updates due to key being removed from the data page during reconciliation" : 0,"history store table truncation to remove range of updates due to out-of-order timestamp update on data page" : 0,"history store table writes requiring squashed modifies" : 0,"in-memory page passed criteria to be split" : 0,"in-memory page splits" : 0,"internal pages evicted" : 0,"internal pages split during eviction" : 0,"leaf pages split during eviction" : 0,"modified pages evicted" : 0,"overflow pages read into cache" : 0,"page split during eviction deepened the tree" : 0,"page written requiring history store records" : 0,"pages read into cache" : 2,"pages read into cache after truncate" : 0,"pages read into cache after truncate in prepare state" : 0,"pages requested from the cache" : 3,"pages seen by eviction walk" : 0,"pages written from cache" : 2,"pages written requiring in-memory restoration" : 0,"the number of times full update inserted to history store" : 0,"the number of times reverse modify inserted to history store" : 0,"tracked dirty bytes in the cache" : 0,"unmodified pages evicted" : 0},"cache_walk" : {"Average difference between current eviction generation when the page was last considered" : 0,"Average on-disk page image size seen" : 0,"Average time in cache for pages that have been visited by the eviction server" : 0,"Average time in cache for pages that have not been visited by the eviction server" : 0,"Clean pages currently in cache" : 0,"Current eviction generation" : 0,"Dirty pages currently in cache" : 0,"Entries in the root page" : 0,"Internal pages currently in cache" : 0,"Leaf pages currently in cache" : 0,"Maximum difference between current eviction generation when the page was last considered" : 0,"Maximum page size seen" : 0,"Minimum on-disk page image size seen" : 0,"Number of pages never visited by eviction server" : 0,"On-disk page image sizes smaller than a single allocation unit" : 0,"Pages created in memory and never written" : 0,"Pages currently queued for eviction" : 0,"Pages that could not be queued for eviction" : 0,"Refs skipped during cache traversal" : 0,"Size of the root page" : 0,"Total number of pages currently in cache" : 0},"checkpoint-cleanup" : {"pages added for eviction" : 0,"pages removed" : 0,"pages skipped during tree walk" : 0,"pages visited" : 1},"compression" : {"compressed page maximum internal page size prior to compression" : 4096,"compressed page maximum leaf page size prior to compression " : 131072,"compressed pages read" : 1,"compressed pages written" : 1,"number of blocks with compress ratio greater than 64" : 0,"number of blocks with compress ratio smaller than 16" : 1,"number of blocks with compress ratio smaller than 2" : 0,"number of blocks with compress ratio smaller than 32" : 0,"number of blocks with compress ratio smaller than 4" : 0,"number of blocks with compress ratio smaller than 64" : 0,"number of blocks with compress ratio smaller than 8" : 0,"page written failed to compress" : 0,"page written was too small to compress" : 1},"cursor" : {"Total number of entries skipped by cursor next calls" : 0,"Total number of entries skipped by cursor prev calls" : 0,"Total number of entries skipped to position the history store cursor" : 0,"Total number of times a search near has exited due to prefix config" : 0,"bulk loaded cursor insert calls" : 0,"cache cursors reuse count" : 2,"close calls that result in cache" : 2,"create calls" : 2,"cursor next calls that skip due to a globally visible history store tombstone" : 0,"cursor next calls that skip greater than or equal to 100 entries" : 0,"cursor next calls that skip less than 100 entries" : 0,"cursor prev calls that skip due to a globally visible history store tombstone" : 0,"cursor prev calls that skip greater than or equal to 100 entries" : 0,"cursor prev calls that skip less than 100 entries" : 1,"insert calls" : 1,"insert key and value bytes" : 2259,"modify" : 0,"modify key and value bytes affected" : 0,"modify value bytes modified" : 0,"next calls" : 0,"open cursor count" : 0,"operation restarted" : 0,"prev calls" : 1,"remove calls" : 0,"remove key bytes removed" : 0,"reserve calls" : 0,"reset calls" : 6,"search calls" : 0,"search history store calls" : 0,"search near calls" : 0,"truncate calls" : 0,"update calls" : 0,"update key and value bytes" : 0,"update value size change" : 0},"reconciliation" : {"approximate byte size of timestamps in pages written" : 0,"approximate byte size of transaction IDs in pages written" : 0,"dictionary matches" : 0,"fast-path pages deleted" : 0,"internal page key bytes discarded using suffix compression" : 0,"internal page multi-block writes" : 0,"leaf page key bytes discarded using prefix compression" : 0,"leaf page multi-block writes" : 0,"leaf-page overflow keys" : 0,"maximum blocks required for a page" : 1,"overflow values written" : 0,"page checksum matches" : 0,"page reconciliation calls" : 2,"page reconciliation calls for eviction" : 0,"pages deleted" : 0,"pages written including an aggregated newest start durable timestamp " : 0,"pages written including an aggregated newest stop durable timestamp " : 0,"pages written including an aggregated newest stop timestamp " : 0,"pages written including an aggregated newest stop transaction ID" : 0,"pages written including an aggregated newest transaction ID " : 0,"pages written including an aggregated oldest start timestamp " : 0,"pages written including an aggregated prepare" : 0,"pages written including at least one prepare" : 0,"pages written including at least one start durable timestamp" : 0,"pages written including at least one start timestamp" : 0,"pages written including at least one start transaction ID" : 0,"pages written including at least one stop durable timestamp" : 0,"pages written including at least one stop timestamp" : 0,"pages written including at least one stop transaction ID" : 0,"records written including a prepare" : 0,"records written including a start durable timestamp" : 0,"records written including a start timestamp" : 0,"records written including a start transaction ID" : 0,"records written including a stop durable timestamp" : 0,"records written including a stop timestamp" : 0,"records written including a stop transaction ID" : 0},"session" : {"object compaction" : 0,"tiered operations dequeued and processed" : 0,"tiered operations scheduled" : 0,"tiered storage local retention time (secs)" : 0,"tiered storage object size" : 0},"transaction" : {"race to read prepared update retry" : 0,"rollback to stable history store records with stop timestamps older than newer records" : 0,"rollback to stable inconsistent checkpoint" : 0,"rollback to stable keys removed" : 0,"rollback to stable keys restored" : 0,"rollback to stable restored tombstones from history store" : 0,"rollback to stable restored updates from history store" : 0,"rollback to stable skipping delete rle" : 0,"rollback to stable skipping stable rle" : 0,"rollback to stable sweeping history store keys" : 0,"rollback to stable updates removed from history store" : 0,"transaction checkpoints due to obsolete pages" : 0,"update conflicts" : 0}},"nindexes" : 1,"indexBuilds" : [ ],"totalIndexSize" : 36864,"totalSize" : 73728,"indexSizes" : {"_id_" : 36864},"scaleFactor" : 1,"ok" : 1}---
