# Very slow index speeds with dynamic mapping and large volume of documents with new fields

**URL:** <https://discuss.elastic.co/t/very-slow-index-speeds-with-dynamic-mapping-and-large-volume-of-documents-with-new-fields/22617>\
**Category:** Elasticsearch\
**Created:** [March 11, 2015, 3:37pm UTC](https://discuss.elastic.co/t/very-slow-index-speeds-with-dynamic-mapping-and-large-volume-of-documents-with-new-fields/22617 "2015-03-11T15:37:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Todd\_Nine](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/todd_nine/32/778_2.png) [@Todd\_Nine](https://discuss.elastic.co/u/Todd_Nine)\
**Post date:** [March 11, 2015, 3:37pm UTC](https://discuss.elastic.co/t/very-slow-index-speeds-with-dynamic-mapping-and-large-volume-of-documents-with-new-fields/22617/1 "2015-03-11T15:37:03Z")

</div>

Hey all,  
We're bumping up against a production problem I could use a hand with.  
We're experiencing steadily decreasing index speeds. We have 12 c3.4xl  
data nodes, and 1 c3.8xl master node (with 2 backups that are smaller).  
We're indexing 45 million documents into a single index. Single shard  
only, no replicas. As our number of documents grow, our indexing speed  
slows to a crawl. We've applied all the standard mlockall, ulimit, and ssd  
merge throttling tuning settings, so I feel our cluster is pretty good.

When I inspected the data, I've noticed our user is adding a new field on  
every document. When I view the pending tasks on our master, the task  
queue is always at least 300+ attempting to perform dynamic mapping. I've  
also checked segment merging, we never have more than 1 merge going on, and  
even then it lasts for a second or two, not long at all.

This brings me to my question. When dynamic mapping is performed, is this  
on the master only? Obviously this would introduce a bottleneck, and  
explain our sudden performance drop. I'm at a loss to explain this issue.  
Any advice would be appreciated.

Thanks,  
Todd

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 13, 2015, 7:12pm UTC](https://discuss.elastic.co/t/very-slow-index-speeds-with-dynamic-mapping-and-large-volume-of-documents-with-new-fields/22617/2 "2015-03-13T19:12:36Z")

</div>

Mapping changes do need to go through the master, so check how it is  
performing.

On 11 March 2015 at 08:37, Todd Nine [tnine@apigee.com](mailto:tnine@apigee.com) wrote:

> Hey all,  
> We're bumping up against a production problem I could use a hand with.  
> We're experiencing steadily decreasing index speeds. We have 12 c3.4xl  
> data nodes, and 1 c3.8xl master node (with 2 backups that are smaller).  
> We're indexing 45 million documents into a single index. Single shard  
> only, no replicas. As our number of documents grow, our indexing speed  
> slows to a crawl. We've applied all the standard mlockall, ulimit, and ssd  
> merge throttling tuning settings, so I feel our cluster is pretty good.
> 
> When I inspected the data, I've noticed our user is adding a new field on  
> every document. When I view the pending tasks on our master, the task  
> queue is always at least 300+ attempting to perform dynamic mapping. I've  
> also checked segment merging, we never have more than 1 merge going on, and  
> even then it lasts for a second or two, not long at all.
> 
> This brings me to my question. When dynamic mapping is performed, is this  
> on the master only? Obviously this would introduce a bottleneck, and  
> explain our sudden performance drop. I'm at a loss to explain this issue.  
> Any advice would be appreciated.
> 
> Thanks,  
> Todd
> 
> --  
> You received this message because you are subscribed to the Google Groups  
> "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an  
> email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/0611317c-d3c1-4894-8fac-8ac4b36cbf15%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAEYi1X-PeZJU%3DnfRpgT0hQ3dbDE\_LKhW8etBAHqVSjbxHXZMMA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAEYi1X-PeZJU%3DnfRpgT0hQ3dbDE_LKhW8etBAHqVSjbxHXZMMA%40mail.gmail.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:26am UTC](https://discuss.elastic.co/t/very-slow-index-speeds-with-dynamic-mapping-and-large-volume-of-documents-with-new-fields/22617/3 "2017-07-06T00:26:53Z")

</div>


