[SERVER-9480] primary shard gets most of the queries Created: 26/Apr/13  Updated: 10/Dec/14  Resolved: 02/May/13

Status: Closed
Project: Core Server
Component/s: Sharding
Affects Version/s: 2.4.2
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: Nemanja Dubravac Assignee: Unassigned
Resolution: Done Votes: 0
Labels: mongostat, query, sharding
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

does anyone know why the primary shard gets most (95%) of the queries?

mongostat shows that the primary mongod of the primary shard gets 400 qps and the primary mongod of the other shard gets only around 20 qps

shard key is

{ _id: 'hashed' }

and queries do not use the shard key, but data should be uniformly balanced on both shards
current chunk ratio between these 2 shards is 703 : 704

this is a test environment, so nothing else is running on these servers

if i "movePrimary" to another shard, then that's the one that will get most of the queries..



 Comments   
Comment by Ian Daniel [ 02/May/13 ]

Hi Nemanja,

Thanks for the update. Resolving now.

Kind regards,
Ian

Comment by Nemanja Dubravac [ 01/May/13 ]

we should close this ticket, as it's totally wrong..
i completely oversaw some other queries from an included class being made on non-sharded collections

sorry for the waste of anyone's time..

Generated at Thu Feb 08 03:20:32 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.