[SERVER-70994] Make analyzeShardKey command return the frequency of top 5 most common shard key values instead of percentiles Created: 01/Nov/22  Updated: 29/Oct/23  Resolved: 10/Apr/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.0.0-rc0

Type: Task Priority: Major - P3
Reporter: Cheahuychou Mao Assignee: Cheahuychou Mao
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-72814 Support looking up original values fr... Closed
Related
related to SERVER-75886 Make analyzeShardKey command return s... Closed
related to SERVER-75887 Complete TODO listed in SERVER-70994 Closed
Assigned Teams:
Sharding NYC
Backwards Compatibility: Fully Compatible
Sprint: Sharding NYC 2023-03-06, Sharding NYC 2023-03-20, Sharding NYC 2023-04-03, Sharding NYC 2023-04-17
Participants:

 Description   

From the design:

mostCommonValues: [
      // Top 5 most common shard key values. To avoid exceeding the 16MB
      // limit for the response, the values would be truncated if they
      // exceed a certain size.
      {value: <shardkey>, frequency: <integer>},
      ...
]



 Comments   
Comment by Githook User [ 10/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-75887 Update TODO item for SERVER-70994
Branch: master
https://github.com/mongodb/mongo/commit/3533badcbe1feb6ddaafbe5274df7884effc2d36

Comment by Githook User [ 15/Feb/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70994 Make analyzeShardKey command correctly return most common values in case where their size exceeds the BSONObj size limit
Branch: master
https://github.com/mongodb/mongo/commit/4dbf5fdf1813ab615a6e7da503692f227c41cf3a

Comment by Githook User [ 10/Feb/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70994 Make analyzeShardKey command return the value and frequency of most common shard key values
Branch: master
https://github.com/mongodb/mongo/commit/3d262046a212691cb18fd062a7f186bf81cf6b56

Generated at Thu Feb 08 06:17:44 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.