[MongoDB]: TTL (Time To Live) collections and Indexes
TTL (Time To Live) indexes are special single-field indexes that MongoDB can use to automatically remove documents from a collection after a certain amount of time. Data expiration is useful for certain types of information like machine generated event data,…
[MongoDB]: DBRef (Database references) usage
DBRefs vs Manual References As an example scenario where we would use DBRefs instead of Manual References, consider a database where we are storing different types of addresses (home, office, mailing, etc) in different collections (address_home, address_office, address_mailing, etc). Now,…
[MongoDB]: To Check fragmentation using a JavaScript
MongoDB Fragmentation Alerting script :- 1) Script will consider below aspects and prompt us “POSSIBLE FRAGMENTATION” & “REVIEW SCHEMA” issues. dataSize indexSize storageSize fileSize 2) It has 6GB minimum threshold dataSize for the database as thumb rule to apply the…
[Linux]: How do I remove ‘Control M’ i.e., (^M) characters from a file
To create a file with “Control M” (^M) characters – you can type Ctrl+V,Ctrl+M from keyboard through vi editor in a linux file. And to view “Control M” characters in a file, you can use “cat -v filename” or “cat…
[MongoDB]: Tailable cursors
Tailable cursors are cursors that remain open even after they’ve returned a final result. This way, if more documents are added to a collection (i.e., to the cursor’s result set), then you can continue to call Cursor#next to retrieve those…
What is AuroraDB ?
Amazon Aurora is a fully-managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. It delivers up to five times the performance of MySQL without requiring changes…
[MySQL]: SQL script to list MyISAM & innodb_file_per_tables
— It needs to be run from an account that has read permission for the INFORMATION_SCHEMA database. select msg as `==> Checking current version of MySQL.` from ( select ‘This script should be run on MySQL version 5.6. ‘ +…
DynamoDB: Amazon’s product
Amazon DynamoDB Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed database and supports both document and key-value data models. Its flexible…
[Actifio]: ESG Labs report & Economical Value Report
* ESG Labs Analyst Report http://www.youtube.com/watch?v=Cc1u6FKOqyM&list=TLSKCduSZqcdY * Economical Value Report http://www.actifio.com/resource-center/?show=analyst-reports