{"id":481,"date":"2017-08-03T13:20:25","date_gmt":"2017-08-03T20:20:25","guid":{"rendered":"http:\/\/www.kenwalger.com\/blog\/?p=481"},"modified":"2017-08-19T10:36:40","modified_gmt":"2017-08-19T17:36:40","slug":"mongodb-performance-issues","status":"publish","type":"post","link":"https:\/\/www.kenwalger.com\/blog\/nosql\/mongodb\/mongodb-performance-issues\/","title":{"rendered":"MongoDB Performance Issues – Fact or Fiction"},"content":{"rendered":"

I see posts and hear conversations quite frequently about MongoDB<\/a> performance issues. They are a frequent, and hot, topic on sites like Quora, Hacker News, and Reddit. Many of these “hits” against MongoDB are based on outdated data and older versions of MongoDB.<\/p>\n

There was a movie from the late 1980’s called Crocodile Dundee II<\/a>\"\". There is a scene in the movie where the guy from the Australian Outback, Mick “Crocodile” Dundee, visits\u00a0a New York City hotel for the first time. Someone shows him that the room has a television. He turns it on and sees an old episode of I Love Lucy<\/a>\"\". Dundee shuts it off claiming he has already experienced television.<\/p>\n

Similarly, many complaints from older versions of MongoDB still linger around. Someone who had a bad experience with an old version will answer a thread somewhere and claim “I used it once, didn’t like it, it’s garbage.” Much like Mick Dundee, they are basing their entire opinion on outdated knowledge.<\/p>\n

Let’s take a look at some performance issues that are often raised and where things sit now with the latest version of MongoDB, 3.4.6<\/a>. I raised some of these aspects in a previous post<\/a>, but let’s take a deeper dive.<\/p>\n

The Jepsen Test &\u00a0Performance Issues of old<\/h3>\n

From a “documented issue” standpoint, many performance issues that plague MongoDB in social reviews are covered in a Jepsen<\/a> test result post from 20 April 2015<\/a>. This was based on version 2.4.3. Or an even older article from 18 May 2013<\/a>. Clearly, there were some issues with data scalability and data concurrency in those earlier versions.<\/p>\n

In fact, Jepsen has done extensive tests on MongoDB on lost updates and dirty and stale reads. Without getting too deep into the hows and whys of what was happening to the data, there were issues with writes when a primary went down, and read & write consistency. These issues have been addressed as of version 3.4.1.<\/p>\n

Product Enhancements<\/h3>\n

With the new data enhancements, MongoDB version 3.4.1 passed all of the Jepsen tests. Kyle Kingsbury, the creator of Jepsen, offered the following conclusions:<\/p>\n

\n

MongoDB has devoted significant resources to improved safety in the past two years, and much of that ground-work is paying off in 3.2 and 3.4.<\/p>\n<\/blockquote>\n

\n

MongoDB 3.4.1 (and the current development release, 3.5.1) currently pass all MongoDB Jepsen tests\u2026.These results hold during general network partitions, and the isolated & clock-skewed primary scenario.<\/p>\n<\/blockquote>\n

You can read more about his conclusions in his published results<\/a>.<\/p>\n

Beyond data security, customers are finding huge benefits in performance in the more current releases of MongoDB. Improvements to, or the introduction of, technologies such as replication compression, the WiredTiger<\/a> storage engine, in memory cache, and performance enhancements to sharding and replica sets have been a win for users.<\/p>\n

WiredTiger Case Study<\/h3>\n

A friend who works at\u00a0Wanderu.com<\/a>, a MongoDB user, was very generous and forthcoming with some information about their MongoDB experience. When choosing a database option they felt that NoSQL<\/a>, and MongoDB specifically, fit their business and data model better than a relational model would. They process a very diverse set of data for their bus and train travel application.<\/p>\n

They take information from a vast assortment of bus and train vendors which arrive in XML, JSON, PDF, CSV, and other formats. Data is then ingested and transformed so that everything works with price checking and booking calls in vendor specific formats. The data model was determined to be incredibly complex and fragile for implementing in a relational database.<\/p>\n

In May 2017, Wanderu migrated to the WiredTiger storage engine in MongoDB 3.4. They took some screenshots of some of their performance graphs. The graphs cover a 10 day period, five before and five after, their migration on 5\/5. They were kind enough to share these images with me and approved of their use in this article.<\/p>\n

Wanderu Charts<\/h6>\n
\"MognoDB<\/a>
Before WiredTiger, the write load had a very limited max. After migration writes spiked as necessary.<\/figcaption><\/figure>\n
\"Queued<\/a>
Writes stayed fairly constant while queued reads fell dramatically.<\/figcaption><\/figure>\n
\"MongoDB<\/a>
Index size took a dramatic decrease in size as well.<\/figcaption><\/figure>\n
\"MongoDB<\/a>
Not surprisingly, Memory Usage dropped too.<\/figcaption><\/figure>\n
\"MongoDB<\/a>
Page Fault improvements<\/figcaption><\/figure>\n
\"Replication
If there wasn’t a doubt, replication lag was improved as well.<\/figcaption><\/figure>\n

In the four years since Wanderu launched, it has relied heavily on MongoDB. They store the station and trip information for each local, regional, and national carrier. With the new $graphLookup<\/a> capability in MongoDB version 3.4, they are looking at the possibility of utilizing that technology for their graphing needs as well.<\/p>\n

Further Industry Thoughts<\/h3>\n

MongoDB is a widely used NoSQL database. It is used by companies large and small, for a variety of reasons. I reached out to a few other known MongoDB users to get some real world feedback and product experiences.<\/p>\n

Carfax<\/h6>\n

CARFAX<\/a>, for example, has been using MongoDB in production since version 1.8. They load over a billion documents<\/a> a year and generate over 20,000 reports per second. Jai Hirsch<\/a>, a Senior Systems Architect at CARFAX, wrote a nice write up<\/a> about why they decided on MongoDB. They have achieved some tremendous performance benefits from compressed replication.<\/p>\n

GHX<\/h6>\n

GHX<\/a> switched from MMAPv1 to WiredTiger with the 3.2 release of MongoDB. Jeff Sherard, their Database Engineering Manager, had another very positive experience.<\/p>\n

Definitely the switch to WiredTiger in 3.2 was a huge boost. Especially on the compression side – we experience about 50% compression. Document level locking vs. Collection level locking also improved performance for us significantly.<\/p><\/blockquote>\n

He also experienced benefits with sharding<\/a> and replica sets<\/a> as well with an upgrade to 3.4.4.<\/p>\n

We recently upgraded to 3.4.4 and are particularly pleased with the improvements in balancing on shards (the parallelism makes balancing really fast). And the initial sync improvements in replica sets [sic] have been really useful too.<\/p><\/blockquote>\n

Tinkoff Bank<\/h6>\n

Tinkoff Bank<\/a> landed on using MongoDB instead of Oracle based on their finding that the performance of Oracle’s CLOBs<\/a>\u00a0are not as fast and are not searchable. They are able to process approximately 1,500 requests per second using their three node replica set. These queries put a load of 5-10% on the CPU of the primary node<\/a>.<\/p>\n

Wrap Up<\/h3>\n

I’m sure that the SQL vs. NoSQL debate will live on. Much the same as Windows vs. Mac, or cats vs. dogs. I hope, however, that based on the information and testimonies provided here we can lay to rest the notion that MongoDB isn’t “enterprise ready.” If we are going to argue the virtues of MongoDB, we should at least be talking about the most current version.\u00a0As in the scene with Mick Dundee, he comes across looking foolish for basing his entire view of a product based on something he experienced years ago.<\/p>\n

There are several MongoDB specific terms in this post. I created a MongoDB Dictionary<\/a> skill for the Amazon Echo<\/a>\u00a0line of products. Check it out and you can say “Alexa, ask MongoDB what is a document?” and get a helpful response.<\/p>\n

\n

Follow me on Twitter @kenwalger<\/a> to get the latest updates on my postings.<\/em><\/p>\n\"Facebook\"<\/a>\"twitter\"<\/a>\"reddit\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"

I see posts and hear conversations quite frequently about MongoDB performance issues. They are a frequent, and hot, topic on sites like Quora, Hacker News, and Reddit. Many of these “hits” against MongoDB are based on outdated data and older versions of MongoDB. There was a movie from the late 1980’s called Crocodile Dundee II. … Continue reading “MongoDB Performance Issues – Fact or Fiction”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pmpro_default_level":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[21],"yst_prominent_words":[742,705,99,300,724,733,716,87,743,711,702,703,750,749,748,781,728,712,746,745],"class_list":["post-481","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","tag-performance","pmpro-has-access"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.kenwalger.com\/blog\/wp-content\/uploads\/2017\/08\/feature-e1501791518387.png?fit=125%2C125&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8lx70-7L","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/posts\/481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/comments?post=481"}],"version-history":[{"count":14,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/posts\/481\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/posts\/481\/revisions\/503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/media\/500"}],"wp:attachment":[{"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/media?parent=481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/categories?post=481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/tags?post=481"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.kenwalger.com\/blog\/wp-json\/wp\/v2\/yst_prominent_words?post=481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}