MongoDB的基本操作

ycsk

浏览: 154766 次
性别:
来自: 南京

最近访客更多访客>>

haining128

WangJiaX

jhelan

ntwjf

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

mongodb

MongoDB nginx F#J#

Mongodb启动：
nohup /byread/bin/mongodb/bin/mongod --dbpath=/byread/mongodb 2>&1 >> /byread/logs/mongodb/mongodb.log &
关闭：
db.shutdownServer()
kill -2 PID
kill -15 PID

创建索引
db.things.ensureIndex({j:1});
1升序，-1降序
索引的作用比较大，下面列出索引前和索引后的两个状态，锁表时间大大减少。

引用

[root@bookweb byread]# /byread/bin/mongodb/bin/mongostat
connected to: 127.0.0.1
insert/s query/s update/s delete/s getmore/s command/s mapped vsize    res % locked % idx miss conn     time
      21       0       20        0         0         1   8141   8308   2755    0.947          0     2 11:31:43
      18       0       18        0         0         1   8141   8308   2755    0.635          0     2 11:31:44
      14       0       14        0         0         1   8141   8308   2755    0.635          0     2 11:31:45
      21       0       20        0         0         1   8141   8308   2755    0.944          0     2 11:31:46
      17       0       16        0         0         1   8141   8308   2755    0.689          0     2 11:31:47
      19       0       18        0         0         1   8141   8308   2755    0.703          0     2 11:31:48
      19       0       19        0         0         1   8141   8308   2755    0.967          0     2 11:31:49
      14       0       14        0         0         1   8141   8308   2755    0.857          0     2 11:31:50
      22       0       22        0         0         1   8141   8308   2755        1          0     2 11:31:51
      16       0       16        0         0         1   8141   8308   2756     0.98          0     2 11:31:52
      17       0       16        0         0         1   8141   8308   2756    0.905          0     2 11:31:53
      19       0       19        0         0         1   8141   8308   2756     1.01          0     2 11:31:54

引用

[root@bookweb byread]# /byread/bin/mongodb/bin/mongostat
connected to: 127.0.0.1
insert/s query/s update/s delete/s getmore/s command/s mapped vsize    res % locked % idx miss conn     time
      16       0       15        0         0         1   8141   8332   2601 0.00182          0     2 12:46:21
      19       0       18        0         0         1   8141   8332   2601 0.00301          0     2 12:46:22
      26       0       25        0         0         1   8141   8332   2601 0.00268          0     2 12:46:23
      18       0       18        0         0         1   8141   8332   2601 0.00177          0     2 12:46:24
      22       0       22        0         0         1   8141   8332   2601 0.00787          0     2 12:46:25
      26       0       25        0         0         1   8141   8332   2601 0.00273          0     2 12:46:26
      23       0       22        0         0         1   8141   8332   2602 0.00219          0     2 12:46:27
      13       0       12        0         0         1   8141   8332   2602 0.00124          0     2 12:46:28

偏移查询
db.users.find().skip(20).limit(10);

范围查询
db.visitlog.find({"visitime" : {'$gt':"2010-08-06 23:59:59",'$lt':"2010-08-31 23:59:59"}})

切换mongodb
kill -2 15392
mv /byread/mongodb /byread/mongodb_07
mkdir /byread/mongodb
nohup /byread/bin/mongodb/bin/mongod --dbpath=/byread/mongodb 2>&1 >> /byread/logs/mongodb/mongodb.log &
killall -9 nginx
/byread/bin/nginx/sbin/nginx
db.lastpage.ensureIndex({byid:1})
db.visitlog.ensureIndex({visitime:-1})

nohup /byread/bin/mongodb/bin/mongod --port=29017 --dbpath=/byread/mongodb_08 2>&1 >> /byread/logs/mongodb/mongodb.log &
/byread/bin/mongodb/bin/mongoexport -h 127.0.0.1:29017 --db bookvisit --collection visitlog -q '{visitime:"2010-08-17"}' -f bookid,host,isvip,byid,visitime,ischarge,isdown,ptid --csv -o /byread/bin/byread/0817.csv
/byread/bin/mongodb/bin/mongoimport --db bookvisit --collection visitlog -f bookid,host,isvip,byid,visitime,ischarge,isdown,ptid --type csv --file /byread/bin/byread/0817.csv --headerline

分享到：