[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: HTML File text.html     HTML File text.html    
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,
Thomas

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>
Date: Tuesday, July 26, 2016 at 10:09 AM
To: Tara Gokey <tgokey@meed.net>
Subject: [MongoDB-JIRA] (SERVER-25279) 100,000 Records issue

[ https://jira.mongodb.org/browse/SERVER-25279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1336337#comment-1336337 ]

Thomas Schubert commented on SERVER-25279:
------------------------------------------

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,
Thomas

100,000 Records issue
---------------------

Key: SERVER-25279
URL: https://jira.mongodb.org/browse/SERVER-25279
Project: Core Server
Issue Type: Question
Affects Versions: 3.2.7
Environment: development server was server m4.4xlarge cents
Reporter: Tara Gokey
Assignee: Thomas Schubert
Fix For: debugging with submitter

to run this query, wireTiger's performance is slow.. 100,000 records.

----------------------
This message was sent from MongoDB's issue tracking system. To respond to this ticket, please login to https://jira.mongodb.org using your JIRA or MMS credentials.

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
Executor error during find command: Operation failed: sort operation used more than the maximum 33554432 bytes of RAM

From: "Thomas Schubert (JIRA)" <jira@mongodb.org>
Date: Tuesday, July 26, 2016 at 10:09 AM
To: Tara Gokey <tgokey@meed.net>
Subject: [MongoDB-JIRA] (SERVER-25279) 100,000 Records issue

[ https://jira.mongodb.org/browse/SERVER-25279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1336337#comment-1336337 ]

Thomas Schubert commented on SERVER-25279:
------------------------------------------

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,
Thomas

100,000 Records issue
---------------------

Key: SERVER-25279
URL: https://jira.mongodb.org/browse/SERVER-25279
Project: Core Server
Issue Type: Question
Affects Versions: 3.2.7
Environment: development server was server m4.4xlarge cents
Reporter: Tara Gokey
Assignee: Thomas Schubert
Fix For: debugging with submitter

to run this query, wireTiger's performance is slow.. 100,000 records.

----------------------
This message was sent from MongoDB's issue tracking system. To respond to this ticket, please login to https://jira.mongodb.org using your JIRA or MMS credentials.

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,
Thomas

Comment by Tara Gokey [ 26/Jul/16 ]

Hi,
Any update?

From: "Thomas Schubert (JIRA)" <jira@mongodb.org>
Date: Tuesday, July 26, 2016 at 7:54 AM
To: Tara Gokey <tgokey@meed.net>
Subject: [MongoDB-JIRA] (SERVER-25279) 100,000 Records issue

[ https://jira.mongodb.org/browse/SERVER-25279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Schubert reassigned SERVER-25279:
----------------------------------------

Assignee: Thomas Schubert

100,000 Records issue
---------------------

Key: SERVER-25279
URL: https://jira.mongodb.org/browse/SERVER-25279
Project: Core Server
Issue Type: Question
Affects Versions: 3.2.7
Environment: development server was server m4.4xlarge cents
Reporter: Tara Gokey
Assignee: Thomas Schubert
Fix For: debugging with submitter

Attachments: text.html

to run this query, wireTiger's performance is slow.. 100,000 records.

----------------------
This message was sent from MongoDB's issue tracking system. To respond to this ticket, please login to https://jira.mongodb.org using your JIRA or MMS credentials.

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>
Date: Monday, July 25, 2016 at 8:48 PM
To: Tara Gokey <tgokey@meed.net>
Subject: [MongoDB-JIRA] (SERVER-25279) 100,000 Records issue

[ https://jira.mongodb.org/browse/SERVER-25279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1335503#comment-1335503 ]

Thomas Schubert commented on SERVER-25279:
------------------------------------------

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,
Thomas

100,000 Records issue
---------------------

Key: SERVER-25279
URL: https://jira.mongodb.org/browse/SERVER-25279
Project: Core Server
Issue Type: Question
Affects Versions: 3.2.7
Environment: development server was server m4.4xlarge cents
Reporter: Tara Gokey
Fix For: debugging with submitter

to run this query, wireTiger's performance is slow.. 100,000 records.

----------------------
This message was sent from MongoDB's issue tracking system. To respond to this ticket, please login to https://jira.mongodb.org using your JIRA or MMS credentials.

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,
Thomas

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?

  • Are you using MongoDB with WiredTiger or WiredTiger by itself?
  • What behavior do you expect to see?
  • Which specific version/s are affected? Are there versions that are not affected?
  • Would you please upload logs that demonstrate this issue?

Thank you,
Thomas

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