Articles in performance

The mystery of etcd's rationed requests

With etcd in beta at Compose, the complexity of workloads on the database has been steadily increasing. That increasing workload means that we get to understand how users' tasks can load our databases as synthetic testing can only do so much. Our und…

Continue reading »

Improved Performance for Redis Cache Mode on Compose

tl;dr - We've boosted the reliability of Cache Mode on Compose by disabling backups and persistence by default on all Redis deployments using that mode. But if you need them enabled, all you need to do is turn it on. We made some changes recently to…

Continue reading »

Faster Performance with Unlogged Tables in PostgreSQL

In the first "Addon" article of this cycle of Compose's Write Stuff, Lucero Del Alba takes a look at how to get better performance with PostgreSQL, as long as you aren't too worried about replication and persistence. Do you want to shed light on a f…

Continue reading »

Compose PostgreSQL's new Performance and Extensions views

The PostgreSQL team at Compose have been busy working on ways for you to get more control over your PostgreSQL deployments and that work is now available for you to use. The new Performance view lets you see how your tables and indexes are doing whil…

Continue reading »

Comparing Hosted Database Performance

While Compose is all about open source databases we also live in the cloud and so does Gary Sieling, who's written this Write Stuff article looking at ways to practically compare database performance across the net, in his case using SQL Server. Many…

Continue reading »

Improve Performance by Removing Query Logic

You know what the following is? db.blog_posts.find({status: {$in: ["draft", "waiting on proof", "approved"]}}).sort({_id: -1}) What is a MongoDB operator? MongoDB operators are commands that compare ranges of values, such as $in, $nin…

Continue reading »

Debunking Myth of RAID 10 as Best Practice on AWS

For the most amazing performance on AWS, use RAID 10 with provisioned i/ops (henceforth piops). A combination of RAID 10 and piops achieved read performance equaling the sum of all provisioned i/ops. Thus, 4 x 1000 piops disks achieved 4000 read i/o…

Continue reading »

MongoDB Slow Queries Tracker & Profiler

Update: This feature was deprecated in March 2016. For further details see this Compose Note. “How can I get more performance from my database?” “Is MongoDB web-scale?” ** Typically, when we answer these questions for MongoDB databases, we are lookin…

Continue reading »

MongoHQ + New Relic = <3

With the release of the New Relic Platform, customers can instantly route MongoHQ database performance metrics to New Relic. Add your New Relic license key to your MongoHQ database, let stand at room temperature for 5 minutes, and (boom) a new Mongo…

Continue reading »

Get Database Alerts - Anywhere

We are excited to announce MongoHQ Alerts feature which will push realtime alerts about your database environment. The typical events include: replica set step down and periods of high lock percentage. Many customers have requested the ability to rec…

Continue reading »