mongovue 以及mongo shell中对日期查询命令的记录

-- in mongovue window {"date":{$lt:ISODate("2013-01-17T01:16:33.303Z")}} 点击find 窗口,然后选择5条记录,就会快速的查询出来   -- in mongo shell window db.tickets.find({"date":{$lt:ISODate("2013-01-17T01:16:33.303Z")}...
阅读(3648) 评论(0)

mongo shell中特殊判断符号转义的问题

[root@mongo ~]# bash -x t.sh + /usr/local/mongodb/bin/mongo 127.0.0.1:37017/test -uadmin -padmin --quiet --eval 'printjson(db.tickets.findOne({date:{:ISODate(2013-01-10T01:16:33.303Z)}},{_id:1}))' F...
阅读(4701) 评论(0)

mongodb清理collection中大量数据的2种办法

1 shell中for循环清理 每次去连接一下mongo, 进行数据的remove操作 echo "Begin ..." >> /root/time.log; echo $(date +%Y-%m-%d-%H:%M:%S) >>/root/time.log; for((i=1;i<=100000000;i++)); do objectid=`/usr/local...
阅读(2658) 评论(6)

"$err" : "not master and slaveok=false", "code" : 13435

monbodb安装完之后, 启动准备添加用户报错. > use admin switched to db admin > db.addUser("admin","admin",false); Wed Apr 24 14:17:26 uncaught exception: error { "$err" : "not master and slaveok=false", "code" : 13...
阅读(3953) 评论(0)

MySQL中3种清除binlog的方法!

-- mysql delete log online 1  mysql命令purge mysql> purge master logs to "mysql-bin.000410"; Query OK, 0 rows affected (3.71 sec)   2 手动rm清理   rm -rf mysql-bin.00040*; vim mysql-bin.log.index...
阅读(2436) 评论(0)

MySQL编译安装的CMake Error: The source directory "/root/mysql-5.6.10/-with-ssl" does not exist.

[root@localhost mysql-5.6.10]# time cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql56   -DMYSQL_DATADIR=/data56 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR==/data56/mysql.sock -DMYSQL_USER=mysql...
阅读(9214) 评论(4)

想从事DBA工作,该挑选哪一款数据库产品

知乎问这原题: 现在主流数据库有很多,作为一个学生以后想从事dba的工作,应该学哪一种呢?   标题修改为:想从事DBA工作,该如何挑选一款数据库产品   mysqlops回答:   不管你想选择哪种数据库产品,有些基础理论知识必须打扎实,尤其是:数据库系统概论、Linux操作系统、SQL标准语言、数据结构(重点排序算法)、开发语言(至少懂几款脚本语言,SHELL必须要会,其次最...
阅读(2595) 评论(3)

EXP-00002: error in writing to export file

exp 报错如下:   exp  xxxx/xxxx@novadb owner=SBXAUD,SBXREP,SBXREP_ETL,SBXRPTAUD,SBXRPTCTRL,SBXTAX  FILE=/home/oracle/sbx.DMP . . exporting table                   TB_DOCUMENTS EXP-00002: error in wri...
阅读(3149) 评论(0)

You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build

wget "http://utopia.knoware.nl/~hlub/rlwrap/rlwrap-0.37.tar.gz" tar -xvf rlwrap-0.37.tar.gz cd rlwrap-0.37 ./configure && make && make check && make install   执行 ./configure && make && make check...
阅读(3008) 评论(0)

Slave_IO_Running: Connecting and Last_IO_Errno: 2003

mysql> show slave status\G *************************** 1. row ***************************                Slave_IO_State: Connecting to master                   Master_Host: 10.88.49.64...
阅读(4346) 评论(0)

innobackupex-1.5.1: Too many command line arguments

[root@xxxxxxopt]# /usr/bin/innobackupex-1.5.1 –-apply-log /opt/back_data/ --defaults-file=/opt/mysql/product/mysql/etc/my.cnf innobackupex-1.5.1: Too many command line arguments   还没有找到问题所在, 去官网...
阅读(4529) 评论(0)

ERROR 2006 (HY000) at line 1: MySQL server has gone away

-- the command of slow.sh was failed ERROR 2006 (HY000) at line 1: MySQL server has gone away ERROR 2006 (HY000) at line 1: MySQL server has gone away cp: missing destination file operand after...
阅读(2694) 评论(0)

How to Setup Public Key Use Globally on SecureCRT

通过SeureCRT创建一个公用的密钥,以后SSH登陆上去不用输入用户名密码   1.Go to "Tools" -> "Create Public Key..." or "Options" > "Global Options" 2.Select "RSA" as key type from the drop down box 3.Set a passphrase to pro...
阅读(1982) 评论(0)

MongoDB安装以及数据初始化海量数据

1 download the install package wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.2.3.tgz 2 uncompress the package tar -zxvf mongodb-linux-x86_64-2.2.3.tgz mv mongodb-linux-x86_64-2.2.3...
阅读(2965) 评论(1)

sqlplus + rlwrap 实现上下键功能

-- sqlplus 实现上下键功能 1  下载 wget "http://utopia.knoware.nl/~hlub/rlwrap/rlwrap-0.37.tar.gz"   2 编译 tar -xvf rlwrap-0.37.tar.gz cd rlwrap-0.37 ./configure && make && make check && make install [ro...
阅读(3445) 评论(3)
    个人资料
    • 访问:3176869次
    • 积分:39857
    • 等级:
    • 排名:第102名
    • 原创:639篇
    • 转载:4篇
    • 译文:2篇
    • 评论:1440条
    博客专栏
    技术网址连接
    http://dev.mysql.com/doc/
    最新评论