[MongoDB] Database 명령어

listCommands

사용할수있는명령어들정보에대해나열한다.

 

listDatabases

서버내의모든데이터베이스목록을조회한다.

 

>db.runCommand( { listDatabases : 1 })

{"errmsg" : "access denied; use admin db", "ok" :0 }

>

> useadmin

switched todb admin

>db.runCommand( { listDatabases : 1 })

{

        "databases" : [

                {

                        "name" :"mydb",

                        "sizeOnDisk": 218103808,

                        "empty" :false

                },

                {

                        "name" :"test",

                        "sizeOnDisk": 218103808,

                        "empty" :false

                },

                {

                        "name" :"local",

                        "sizeOnDisk": 1,

                        "empty" :true

                }

        ],

        "totalSize" : 436207616,

        "ok" : 1

}

 

getLastError

마지막으로수행했던명령어에대한에러여부와명령으로인해영향받은문서수를반환한다.

 

>db.runCommand( { getLastError : 1 } )

{

"n" : 0,

"connectionId" : 1,

"err" : null,

"ok" : 1

}

 

buildInfo

mongoDB의버전과 OS정보를확인한다.

 

>db.runCommand( { buildInfo : 1 } )

{

"version" : "2.2.1",

"gitVersion" : … ,

"sysInfo" : … ,

"versionArray" : … ,

"bits" : 64,

"debug" : false,

"maxBsonObjectSize" : 16777216,

"ok" : 1

}

 

collStats

지정된컬렉션의저장공간등의통계정보를조회한다.

 

>db.runCommand( { "collStats" : "person" } )

{

        "ns" :"test.person",

        "count" : 2,

        "size" : 228,

        "avgObjSize" : 114,

        "storageSize" : 4096,

        "numExtents" : 1,

        "nindexes" : 1,

        "lastExtentSize" : 4096,

        "paddingFactor" : 1.004,

        "systemFlags" : 0,

        "userFlags" : 0,

        "totalIndexSize" : 8176,

        "indexSizes" : {

                "_id_" : 8176

        },

        "ok" : 1

}

 

serverStatus

서버에대한통계를반환한다.

 

>db.runCommand({serverStatus: 1})

{

        "host" :"TIGERFIVE",

        "version" :"2.2.1",

        "process" :"mongod",

        "pid" : 1524,

        "uptime" : 15079,

        "uptimeMillis" :NumberLong(15078464),

        "uptimeEstimate" : 14051,

        "localTime" :ISODate("2013-01-06T19:48:29.297Z"),

…

}

 

ping

현재서버가살아있는지확인한다.

 

> db.runCommand({ping:1})

{"ok" : 1 }

 

isMaster

현재서버가마스터상태인지확인한다.

 

>db.runCommand( { isMaster : 1 })

{

        "ismaster" : true,

        "maxBsonObjectSize" :16777216,

        "localTime" :ISODate("2013-01-06T19:53:43.647Z"),

        "ok" : 1

}

 

shutdownServer

DB를중지하기위해사용한다.

 

>use admin

Switchedto db admin

 

>db.shutdownServer();

servershould be down...