[MongoDB]: Max Query buffer size
Most of you, if you run a query with more than 4096 characters, you’ll see error as below. SyntaxError: Unexpected token ILLEGAL I know lots of have below queries in mind ? 1) What is max size query…
Joins in MongoDB ($lookup)
Performs a left outer join to an unsharded collection in the same database to filter in documents from the “joined” collection for processing. Joins in MongoDB is introduced in MongoDB 3.2 with $lookup aggregate. Compared to SQL server it is…
MongoDB YCSB with Sar – Automated script
[ root @ DBVERSITY: /opt/ycsb/ycsb ] ll -lhtr total 6.9M -rw-r–r– 1 1000545644 2000048971 3.0K Jan 3 2014 workloada -rw-r–r– 1 1000545644 2000048971 209 Jan 3 2014 root.iml -rw-r–r– 1 1000545644 2000048971 952 Jan 3 2014 README -rw-r–r– 1…
Fresher Openings in Deloitte, Wipro – Hyd/B’lore/Pune
Wipro Fresher Openings at Pune *Need urgently 275 BE computers candidates with or without experience for wipro pune location.* *Pls inform anybody if u know.* *Salary 35 to 45 k take home. 2 years bond. Confirmation based on work…
MariaDB/MySQL Database Hardening
1) Start the server using –skip-show-database option. 2) All LOAD DATA LOCAL statements can be disabled from the server side by starting mysqld with the –local-infile=0 option. 3) Disable command history by setting MYSQL_HISTFILE to /dev/null or linking mysql_history to…
[MariaDB]: How to disable load data and enable skip_show_database
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed “s/#skip-show-database/skip-show-database/g” my.cnf | grep skip skip-show-database [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed -i “s/#skip-show-database/skip-show-database/g” my.cnf [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] […
how to disable mysql_history in MariaDB/MySQL
MariaDB/MySQL stores the commands typed in the mysql> prompt in the ~/.mysql_history file. [ root @ dbversity : ~ ] ll -lhtr .mysql_history -rw——- 1 root root 19K Jun 15 06:12 .mysql_history [ root @ dbversity : ~ ] …
Don’t miss the 2nd annual MongoDB Community Open House
Maybe people from Percona at this event will be able to tell us why they are more focused on MongoDB instead of MariaDB… View in browser Mark your calendar! We’re excited to announce the 2nd annual…
DBVersity at Paper.li
The mongodb Daily Published by DBVersity MongoDB 10 June 2016 Science Technology Leisure Business Education #mongodb #javascript Today’s headline MongoDB queries don’t always return all matching documents! — Meteor Engineering engineering.meteor.com – When I query a database, I generally expect…
MongoDb Interview questions
1.What makes MongoDB the best? MongoDB is considered to be best NoSQL database because of :Document-oriented (DO) High performance (HP) High availability (HA) Easy scalability Rich query language 2.How to do transactions/locking in MongoDB? MongoDB does not use conventional locking…