Linux: Sorting a File Here’s simple ‘sort’ command that will remove the duplicate entry from any file and sort in ascending order:Consider a file with few numbers: [root@myhost tmp]# cat testSort.txt 23 4 56 001 34 3 To sort it:…
MySQL: SELECT / LOAD in Batch Here’s are the MySQL commands to extract data from table and to load data into tables. Unlike other DBMS, MySQL offers SELECT..INTO.. and LOAD DATA.. commands are quite faster and convenient. Data would be…
Here’s is a simple MongoDB ‘mongoexport’ command syntax to backup the document/database. This command can be used to backup based on particular conditions (‘where’ clause) Go to MongoDB bin directory and execute as below:./mongoexport –host localhost –port 10000 -d doc_name…
If you’re using MySQL Replication, in rare cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…
While we usually deal with huge data, we come across situations where we need to copy such data from one server/host to a remote host. One of the useful command is ‘rsync‘, which is faster than the traditional scp command!…
While you have a basic idea about MySQL, I would recommend the real-time trial and error than just reading out. For that, download a latest stable community version of MySQL from the official website. Though MySQL is platform independent, its…
Here is a comparison between MongoDB and Relational database, MySQL: Because of distributed key value store, MapReduce calculation capability and document oriented NoSQL features, MongoDB® is The database for Big Data processing.
While mongo shell provides an excellent non-GUI way to interoperate with the data, there are many GUI tools available to view/modify MongoDB data and also to provide support for administrative tasks in a more graphical manner. Best place to start…
Let’s say you have a query which takes around 120 ms to execute without indexes i can assure you that with proper indexes you can reduce that time by at least 10 times in MongoDB. Let me show you with…
If MongoDB installed successfully through RPM installation/any other process, you’ll usually see the below Mongo binaries in the bin (eg. */opt/mongodb/bin*) folder which will be useful to start the Mongo processes (mongod&mongos). [user@hostname bin]$ pwd /opt/mongodb/bin [user@hostname bin]$ ls -lthr…