luoganttcc的博客

db.users.aggregate([{$group: {_id: '$name'} }])

db.runCommand({ touch: 'snapshot', data: true, index: true})

链接 db.stats(); { "db" : "xxx", //当前数据库 "collections" : 27, //当前数据库多少表 "objects" : 18738550, //当前数据库所有表多少条数据 "avgObjSize" : 1153.54876188392, //每条数据的平均大小 "dataSize" : 21615831...

sudo apt-get purge mongodb 或者 sudo apt-get purge --auto-remove mongodb

from pymongo import MongoClient client=MongoClient('localhost',27017) db=client.adv.message from datetime import datetime import pandas as pd #db.insert_one({'player_id':js2['player_id'],'message':j...

storage: dbPath: /var/lib/mongodb journal: enabled: true # engine: # mmapv1: wiredTiger: engineConfig: cacheSizeGB: 0.5

安装 卸载 完全卸载 sudo service mongod stop　　#停止服务 sudo service mongod start　　#启动服务 sudo service mongod restart #重新启动服务 sudo service mongod status #查看状态 mongodb 安装一定要安装3.0以上的版本，2.6那个版本太吃内存 Failed to start mo...

Failed to start mongod.service: Unit mongod.service not found sudo systemctl enable mongod sudo service mongod restart

#db.insert({'name':'lg'}) #db.update({'name':'lg'}, {'$set': {'content':"tt",'name':'luoganttcc','son':'cc'}})

单位是Ｍ db.stats(1048576); 单位是Ｇ db.stats(1073741824);

从远程数据表拉取数据到本地json文件 mongoexport --host 远程服务器IP --port 远程服务器端口 --username 远程数据库用户名 --password 远程数据库密码 --db 数据库名 --collection 数据表名 -q "{_id: ObjectId('')}" --out /home/user/Public/table.json 将本地json文件...

studio-3t下载 3t在linux 下安装非常方便，直接解压即可！ 运行：在bin文件夹下打开terminal ./studio-3t.sh

query= { 'weekend':tt,'$or': [ { 'markup':{'$gt':1000} }, {'markup':{'$lt':-1000} } ]}

#!/usr/bin/env python3 # -*- coding: utf-8 -*- """ Created on Mon Apr 30 21:40:25 2018 @author: luogan """ import tushare as ts import talib from matplotlib import pyplot as plt #通过tushare获取股票信息 df=t...

lt=client.fangjia.district_stat_all_0416 dl = dt.find(query) bf=[] for m in dl: bf.append(m) if len(bf)==20000: lt.insert_many(bf) bf=[] lt.insert_many(bf)

文章链接

import datetime today = datetime.datetime.now() now_time=datetime.datetime(today.year, today.month, today.day, 0, 0, 0) week_time = now_time.weekday() future_time = now_time-datetime.timedelta(days=we...

gg

{ rent_avg_price: { "$type": 2}}

import pymongoclient = pymongo.MongoClient('192.168.0.136',27017) db = client.fangjia_stat cl=db.rent_average_lg1013.distinct("city") ll=list(cl) print(ll)

{weekend:{$gt:new Date(2017,0,31)}}t