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

Make analyzeShardKey command support sampling documents

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 7.1.0-rc0, 7.0.0-rc7
    • None
    • None
    • None
    • Fully Compatible
    • v7.0
    • Sharding NYC 2023-06-26, Sharding NYC 2023-07-10

    Description

      According to the experiments in SERVER-68763, the aggregate command run by the analyzeShardKey command to calculate the metrics about the characteristics about the shard key can take up to hours to run if the collection contains hundreds of millions of documents and the cardinality of the shard key is also very large. Given this, we should make the command support calculating metrics based on sampled documents instead of all of documents in the collection.

      Attachments

        Activity

          People

            cheahuychou.mao@mongodb.com Cheahuychou Mao
            cheahuychou.mao@mongodb.com Cheahuychou Mao
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: