Reputation
896
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 10
Newest
 Yearling
Impact
~19k people reached

18h
answered Adding wiredtiger nodes to a non-wiredtiger replica set
1d
comment Adding wiredtiger nodes to a non-wiredtiger replica set
Setting the tcp_keepalive_time has definitely fixed the problem for other users with the same issue. I don't think you have a choice of not going through the Azure balancer or some other network gear that has the keepalive issue, so it's definitely worth a try. Note: In case you didn't check my profile .. I work for MongoDB ;-).
1d
comment Adding wiredtiger nodes to a non-wiredtiger replica set
tcp_keepalive_time should be lowered as to 120 as per the production notes: "The TCP keepalive on the Azure load balancer is 240 seconds by default, which can cause it to silently drop connections if the TCP keepalive on your Azure systems is greater than this value. You should set tcp_keepalive_time to 120 to ameliorate this problem."
Jul
3
comment Adding wiredtiger nodes to a non-wiredtiger replica set
What is your tcp_keep_alive setting? That's the key one for Azure (especially if you are getting network timeouts). Insufficient ulimits will generally catch you at a later point in the initial sync process.
Jul
3
comment Adding wiredtiger nodes to a non-wiredtiger replica set
Have you reviewed the production notes for Linux & Azure? In particular I would make sure you have reduced the tcp_keep_alive timing to 120 seconds and increased your ulimits from the default before doing the initial sync.
Jul
3
comment Adding wiredtiger nodes to a non-wiredtiger replica set
You have to resync the data because the storage formats on disk are different. Are you getting a specific error during the initial sync? What is your specific O/S version and hosting type (eg AWS, Azure, bare metal, ...)?
Jul
2
comment MongoDB fsyncUnlock won't unlock occasionally on Windows
What version of MongoDB are you using (and if MongoDB 3.0, what storage engine)?
Jun
29
comment Ring topology support of MongoDB ReplicaSet and Sharding?
NB: Not directly related to the topology question, but you should definitely upgrade to the latest production version for your branch of MongoDB (currently 2.4.14) as there have been a number of important bug, stability, and security fixes in the two years since 2.4.5 was released (ref: release notes for MongoDB 2.4).
Jun
29
answered Ring topology support of MongoDB ReplicaSet and Sharding?
Jun
27
revised What data structure is used for MongoDB 3.x geospatial indexes?
Clean up wording of question title
Jun
27
comment MongoDB C# driver fails to reconnect after stepDown
Assuming you have the correct connection string, the expected behaviour is that the driver will automatically discover any changes in your deployment as a result of elections or replica set / sharding configuration. There will be a brief window of exceptions raised for situations where a primary is currently unavailable, but writes will switch to a newly elected primary. Can you include an example of your connection string?
Jun
27
suggested approved edit on What data structure is used for MongoDB 3.x geospatial indexes?
Jun
27
comment Mongo is using 5-7% of CPU, so why is my computer so slow?
CPU generally isn't the limiting factor for MongoDB, particularly if you are doing simple inserts. If the whole instance is slow, I/O and memory are more likely resource constraints .. you need to look at metrics such as iostat and page faults. You also haven't indicated your EC2 instance type or storage configuration, but I wouldn't have any great performance expectations for free tier or low cost instances (eg. micro & small ).
Jun
27
answered how to make secondary slave as readable in MongoDB?
Jun
26
comment Data dump from Mongo to CSV
The utilities you've mentioned (screen and nohup) are for keeping terminal sessions or processes running if your terminal disconnects. I would suggest screen is a more suitable tool for long running sessions because you can resume an interactive shell .. but either of those should work. I would expect that the speed of mongoexport should be unrelated to the utility you are using the start the process (and more strongly correlated with other load on your MongoDB deployment), but in any case it seems like you've already answered the question for your environment.
Jun
26
comment Mongodb high lock percentage / slow queries
@Alistair Worth posting a separate question on a query/update that has variable performance. If there are multiple candidate indexes, perhaps a poor index is periodically being chosen? You should include the output of 'explain(true)' for the query which will show more details on the candidate indexes considered. Also to note: query timing with explain() is expected to be slower than the actual runtime of the query as you are forcing plan evaluation.
Jun
26
comment Why is our Non-Mapped Virtual memory usage high when running MongoDB (MMAP) on CENTOS
Each database connection (active or idle) is allocated 1MB of RAM. Other reasons for increased non-mapped virtual memory usage are server-side processing (JavaScript, Map/Reduce, aggregation, in-memory sorts, ...). What is the role of the Linux machines as compared to the Windows machine in your replica set (i.e. primary vs secondary)? Are you doing secondary reads (default is all reads/writes directed to the primary)?
Jun
26
comment how to make secondary slave as readable in MongoDB?
Are you referring to mongo shell sessions, or access via driver?
Jun
16
comment Mongodb high lock percentage / slow queries
Have you checked indexes and explained your slow queries? Note: you won't see any queries slower than 100ms in the logs because that's the default slow query threshold. If you can share the logs there is probably helpful context such as other slow operations. I would recommend watching Asya's talk on Debugging & Diagnostics for some background on performance troubleshooting.
Jun
16
comment Does the MongoDB background flush (MMAP) update the entire document even if only a small portion has changed? i.e. set on an array position
What specific version of MongoDB and O/S are you using, and what sort of storage config (file system & disk type)? Also, how long are your average flush times? Flush times are only part of the overall picture so in isolation it's hard to guess what the problem might be. Are you using a monitoring service like MMS? If so, are there any other metrics that appear to correlate with your long flush times?