[SERVER-24139] Insert speed decrease rapidly Created: 13/May/16  Updated: 14/Jul/16  Resolved: 14/Jul/16

Status: Closed
Project: Core Server
Component/s: WiredTiger
Affects Version/s: 3.2.5
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: chensi Assignee: Kelsey Schubert
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: HTML File 256B_13000W     File metrics.2016-05-12T06-39-43Z-00000     File metrics.2016-05-12T17-29-53Z-00000    
Issue Links:
Duplicate
duplicates SERVER-24580 Improve performance when WiredTiger c... Closed
Participants:

 Description   

Machine: 24cores, 64GB memory, 1T ssd
Mongo: 3.2.5 WT engine (default config)
using YCSB to insert 130million records (length 256Byte), in the first 40mins, 8~9wQPS, then the thoughout decrease to 1~2wQPS.
we record the mongostat below



 Comments   
Comment by Kelsey Schubert [ 14/Jul/16 ]

Hi hustchensi,

Sorry for the silence, we've examined the diagnostic data you have provided and determined that the behavior you are observing will most likely be corrected by SERVER-24580 included in MongoDB 3.2.8, which significantly improves performance when the WiredTiger cache is full.

I would recommend upgrading to MongoDB 3.2.8, and confirming that this issue is resolved. If you still encounter this issue after upgrading please comment and we will reopen this ticket.

Thank you,
Thomas

Comment by chensi [ 16/May/16 ]

If i change a new collection for insert, it can recover to 8~9wQPS.

Comment by Ramon Fernandez Marina [ 13/May/16 ]

hustchensi, can you please upload the contents of the diagnostics.data directory from your dbpath?

Thanks,
Ramón.

Generated at Thu Feb 08 04:05:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.