[SERVER-25279] 100,000 Records issue Created: 25/Jul/16 Updated: 27/Jul/16 Resolved: 27/Jul/16 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 3.2.7 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Tara Gokey | Assignee: | Kelsey Schubert |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
development server was server m4.4xlarge cents |
||
| Attachments: |
|
| Participants: |
| Description |
|
to run this query, wireTiger's performance is slow.. 100,000 records. |
| Comments |
| Comment by Kelsey Schubert [ 27/Jul/16 ] |
|
Hi tgokey, From your responses, I do not see anything to indicate a bug in the MongoDB server. For MongoDB-related support discussion please post on the mongodb-users group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-users group. See also our Technical Support page for additional support resources. Thank you, |
| Comment by Tara Gokey [ 26/Jul/16 ] |
|
At times.. there are up to 2500 count queries running and at other times only 300 in the same execution process on a per second in Mongostat. Let me know if you need more info, Can we call you or you call us? 818-818-1170 = Shahwar will be taking the call as he is the DBA. From: "Thomas Schubert (JIRA)" <jira@mongodb.org> Thomas Schubert commented on Hi tgokey, Would you please clarify which query is slow, and why you expect it to be faster? Additionally, would you please provide the output of the cursor.explain(true)? Thank you, 100,000 Records issue Key: to run this query, wireTiger's performance is slow.. 100,000 records. ---------------------- The information in this electronic mail message is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. Any review, retransmission, dissemination or other use of or taking of any action by persons or entities other than the intended recipient is prohibited and may be unlawful. Sender is not liable for any loss or damage arising in any way from this message or its attachments. |
| Comment by Tara Gokey [ 26/Jul/16 ] |
|
Questions 1. Is there a happy medium with the number of open connections for 100K records? Error below From: "Thomas Schubert (JIRA)" <jira@mongodb.org> Thomas Schubert commented on Hi tgokey, Would you please clarify which query is slow, and why you expect it to be faster? Additionally, would you please provide the output of the cursor.explain(true)? Thank you, 100,000 Records issue Key: to run this query, wireTiger's performance is slow.. 100,000 records. ---------------------- The information in this electronic mail message is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. Any review, retransmission, dissemination or other use of or taking of any action by persons or entities other than the intended recipient is prohibited and may be unlawful. Sender is not liable for any loss or damage arising in any way from this message or its attachments. |
| Comment by Kelsey Schubert [ 26/Jul/16 ] |
|
Hi tgokey, Would you please clarify which query is slow, and why you expect it to be faster? Additionally, would you please provide the output of the cursor.explain(true)? Thank you, |
| Comment by Tara Gokey [ 26/Jul/16 ] |
|
Hi, From: "Thomas Schubert (JIRA)" <jira@mongodb.org> Thomas Schubert reassigned Assignee: Thomas Schubert 100,000 Records issue Key: Attachments: text.html to run this query, wireTiger's performance is slow.. 100,000 records. ---------------------- The information in this electronic mail message is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. Any review, retransmission, dissemination or other use of or taking of any action by persons or entities other than the intended recipient is prohibited and may be unlawful. Sender is not liable for any loss or damage arising in any way from this message or its attachments. |
| Comment by Tara Gokey [ 26/Jul/16 ] |
|
Hello I have uploaded the gzip file From: "Thomas Schubert (JIRA)" <jira@mongodb.org> Thomas Schubert commented on Hi tgokey, I've moved this ticket for the SERVER project, since you've run into this issue using MongoDB and not standalone WiredTiger. Would you please upload the archive to this secure upload portal? Thank you, 100,000 Records issue Key: to run this query, wireTiger's performance is slow.. 100,000 records. ---------------------- The information in this electronic mail message is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. Any review, retransmission, dissemination or other use of or taking of any action by persons or entities other than the intended recipient is prohibited and may be unlawful. Sender is not liable for any loss or damage arising in any way from this message or its attachments. |
| Comment by Kelsey Schubert [ 26/Jul/16 ] |
|
Hi tgokey, I've moved this ticket for the SERVER project, since you've run into this issue using MongoDB and not standalone WiredTiger. Would you please upload the archive to this secure upload portal? Thank you, |
| Comment by Tara Gokey [ 25/Jul/16 ] |
|
hello I gzip file with mongod.conf and logs.. I can't see to attach |
| Comment by Kelsey Schubert [ 25/Jul/16 ] |
|
Hi tgokey, Unfortunately, there is not enough information provided in this ticket to investigate the behavior you report. To help us get started, would please answer the following questions?
Thank you, |