Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-9480

primary shard gets most of the queries

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Works as Designed
    • Affects Version/s: 2.4.2
    • Fix Version/s: None
    • Component/s: Sharding

      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..

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: