[SERVER-20126] Count on GridFS fs.files and fs.chunks slow Created: 26/Aug/15 Updated: 03/Oct/15 Resolved: 03/Oct/15 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | GridFS |
| Affects Version/s: | 3.0.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | carl dong | Assignee: | Sam Kleinman (Inactive) |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
| Operating System: | ALL |
| Steps To Reproduce: | Just heavy load to count fs.chunks and fs.files with command : |
| Participants: |
| Description |
|
Issue happen on the secondary instance which we do some read operation on it , there are only around 200+ rows in fs.chunks and fs.files collections , our application counts both collections but it cost a long time to return result : sample log :
db stats like this :
ADFileSource is not a big database , CPU usage is not high , so the bottleneck should not be the cpu. Attached some status logs(dblog , serverstatus and iostats) for your analysis. Thanks Carl |
| Comments |
| Comment by Sam Kleinman (Inactive) [ 11/Sep/15 ] |
|
Sorry for the delay in getting back to you, and thanks for the data. I have a couple of questions about this issue:
Regards, |