[SERVER-67332] Add Free Storage Totals for Collection Stats Created: 16/Jun/22  Updated: 31/Jul/23  Resolved: 31/Jul/23

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

Type: Improvement Priority: Minor - P4
Reporter: Diego Rodriguez (Inactive) Assignee: Backlog - Storage Execution Team
Resolution: Won't Do Votes: 0
Labels: execution-product-sync
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Storage Execution
Participants:

 Description   

Hi Team,

Currently, when we show the collection stats we show the following values (among many others, of course):

Similarly to what we show in the database stats, it would be helpful if we added the following totals:

  • totalIndexFreeStorageSize: sum of the free (re-usable) space for all indexes on the collection.
  • totalFreeStorageSize: sum of the free (re-usable) space for all indexes on the collection + the collection itself.

Since we already show totals for indexes (totalIndexSize and totalSize) I assume this won't result in any meaningful extra work that might hurt performance but that's an aspect that should be considered as deployments with many indexes for a collection might be affected if meaningful additional work is needed to add the proposed totals. If that's the case, we could safeguard showing these totals under a specific option for the collection stats command.

This doesn't affect a specific version, it's something that it would be good to consider for all of them as long as back-porting is possible.

Regards
Diego



 Comments   
Comment by Irwin Dolobowsky [ 31/Jul/23 ]

See previous comment.

This space is not actually free and is still in use.  Once it is truly free it will show up in the existing free stats.

Comment by Irwin Dolobowsky [ 31/Jul/23 ]

I'm going to close this for now.

While this space is technically free for re-use, it is not actually available and still considered in use until it is specifically freed.  At that point the existing free space stat would be updated.  Until then it is considered in use by Indexes.  Having another free space stat might cause more confusion for customers thinking they can use it or have more free space than they actually do.

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