Subject: [mongodb-user] Re: Is WiredTiger recommended for a
update heavy write load?
Hi Asya,Would be great if you can comment on this topic. Thank you in advance.
On Thursday, July 27, 2017 at 4:16:39 PM UTC-7, kaushik subramanian wrote:Hello all,We have an analytics platform that uses MongoDB as the underlying data store to store and retrieve many different time series. Long story short here is what we have now- MongoDB 3.2 with WiredTiger storage engine- zlib compression- Minute based documents: Data is being exported from a given device once every minute and there are hundreds of such devices. Every datapoint translates to a new insert.- The load was purely insert heavy and there were on updates at all.
Now that we are a little wiser than before, we are moving to a time series based schema where every record will hold data for 1 hour. So here is how it will be,- MongoDB 3.2 with WiredTiger storage engine- zlib compression- preallocate 1-hour documents: Data is still being exported from a given device every minute and there are hundreds of such devices. Every datapoint translates to an update for the respective hour-based document.- The load just got converted to a update heavy load.
WiredTiger documentation says that there is no longer support for inplace update. Given that fact, is WiredTiger well suited for an update heavy write load?
As far as the read load is concerned, we are not too heavy on reads as we are on writes. The reason i say this is because, data is being generated every minute by hundreds of devices and the users retrieving the data do not come close to generating a heavy read load.
Would appreciate some insights on this one!!
You received this message because you are subscribed to the Google Groups "mongodb-user"
For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
You received this message because you are subscribed to the Google Groups "...
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]
To post to this group, send email to [email protected]
Visit this group at https://groups.google.com/group/mongodb-user
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/966227b7-a0f2-4afb-b1ec-5dd545983d9c%40googlegroups.com
For more options, visit https://groups.google.com/d/optout