View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. Hardware
August 20, 2019

Amazon DocumentDB Speeds Up With Slow Queries Logging

"We recommend that you start with a high threshold value."

By CBR Staff Writer

Amazon continues to add extra supports to its non-relational database store DocumentDB with the addition of slow queries logging.

Slow queries logging allows user to monitor their slowest queries in the cluster. This helps to improve overall performance of the cluster and the individual query.

Once the user has enabled a set profiler for the query the system will monitor operations and if any queries run longer than the customer-defined threshold, set at 100ms by default, the system will log their execution time and send an alert to the CloudWatch Logs.

The system will log details such as profiled command line, plan summary and client metadata.

AWS notes that: “When enabled, profiler utilizes additional resources in your cluster. We recommend that you start with a high threshold value (i.e., 500ms) and gradually lower the value to identify slow operations. Starting with a threshold value of 50ms can cause performance issues on your cluster for high throughput applications. Profiler is enabled at the cluster level and is performed on all instances and databases in a cluster.”

Amazon DocumentDB and MongoDB

DocumentDB is a non-relational databases that stores documents in flexible, binary representations called BSON (Binary JSON). This means fields can vary from document to document and data structure can be changed over time; as opposed to relational database management system like Oracle’s MySQL, which store data in tables and use structured query language for database access.

Amazon DocumentDB uses MongoDB’s 2017 open source-licensed 3.6 API to ape the responses that a MongoDB client expects from a MongoDB server. This allows customers to use their existing MongoDB drivers. DocumentDB automatically scales up to 64TB of data per cluster.

Content from our partners
Green for go: Transforming trade in the UK
Manufacturers are switching to personalised customer experience amid fierce competition
How many ends in end-to-end service orchestration?

MongoDB itself is now on 4.0 and is no longer fully open source. Last year MongoDB changed their licensing agreements from a GNU AGPLv3, (companies who wish to use their code for commercial reasons should open source their software), to a Server Side Public License (SSPL).

Last January a MongoDB spokesperson told Computer Business Review that: “Customers want the real thing rather than some feature-limited imitation, and no customer is demanding to be locked into a single vendor’s ecosystem… Our initial testing shows that DocumentDB has the same shortcomings in functionality as similar imitation products that have been on the market for years, and those have not slowed the growth of MongoDB.”

“Important recent MongoDB features such as multi-document ACID transactions, change streams and global clusters are all absent, as are a host of older core capabilities, such as joins and even schema  support–features MongoDB has had for years. Ironically, while it was the massive popularity and momentum of MongoDB that drove AWS to make this announcement, we believe this announcement will only… drive other AWS customers to the real MongoDB global cloud database, MongoDB Atlas.”

See Also: UK Ransomware Attacks Soar 195% – Malware Cocktails Proliferate

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how New Statesman Media Group may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.