[SERVER-76311] Limit the disk space used for storing sampled queries Created: 19/Apr/23  Updated: 29/Oct/23  Resolved: 26/Apr/23

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

Type: Bug 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:
Backports
Issue split
split to SERVER-76477 Cap the size of the collections stori... Open
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v7.0
Sprint: Sharding NYC 2023-05-01
Participants:

 Description   

To prevent query sampling from using an unreasonable amount of disk space when a user forgets to turn off query sampling after they finish analyzing a shard key or when the sample rate is low but the queries are just so large in size, we should:

  • The config.sampledQueries and config.sampledQueriesDiff should exist as capped collections, with a size cap of 10GB.
  • Set the upper bound for the sampleRate to 1000. 


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

Author:

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

Message: SERVER-76311 Set upper limit for the sampleRate in configureQueryAnalyzer command

(cherry picked from commit 6d2bc33eb6959a2228e758777ed00359692ddd54)
Branch: v7.0
https://github.com/mongodb/mongo/commit/a6fc9c851f951303a14aa4fb8d1f61a0b58b60b1

Comment by Githook User [ 26/Apr/23 ]

Author:

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

Message: SERVER-76311 Set upper limit for the sampleRate in configureQueryAnalyzer command
Branch: master
https://github.com/mongodb/mongo/commit/6d2bc33eb6959a2228e758777ed00359692ddd54

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