Getting Data In

Does dbinspect output include cluster replication (RF) configuration?

Beaker77
Explorer

Oh Hai Splunkers!

I've been trying to find out how much disk is being used and the associated compression ratio for a specific index. There's been some great examples using dbinspect like the following:

| dbinspect index=myIndexName
| fields state,id,rawSize,sizeOnDiskMB 
| stats sum(rawSize) AS rawTotal, sum(sizeOnDiskMB) AS diskTotalinMB
| eval rawTotalinMB=(rawTotal / 1024 / 1024) | fields - rawTotal
| eval compression=tostring(round(diskTotalinMB / rawTotalinMB * 100, 2)) + "%"
| table rawTotalinMB, diskTotalinMB, compression

The output of this is what I'm after but I'm using a clustered environment, and am wondering if the sizeOnDiskMB value includes the replication factor or not?

For example, if I have an effective RF of 2, would I have to device the results of the above search by two to get the true size value of a single copy of the data?

Thanks in advance!

0 Karma
1 Solution

amitm05
Builder

@Beaker77

Yes, sizeOnDiskMB will include the replication factor here. We should understand that RF means No. of copies of buckets that we have on the disk. Though these are not searchable copies and so might consume a little less space than searchable copies (which also includes tsidx files). But I guess the question is not ablout less or more space here.
So the answer is yes, "sizeOnDiskMB" will include the replicated copies of data as well.

Let me know if this answers you by marking this as answer and upvoting.
Thanks

View solution in original post

harsmarvania57
Ultra Champion

Hi,

Yes dbinspect includes replication bucket as well. If you run below query and sort by id , you will able to see same bucket id twice (if you have RF=2)

| dbinspect index=qualys
| fields state,id,rawSize,sizeOnDiskMB,guId,bucketId,path

amitm05
Builder

@Beaker77

Yes, sizeOnDiskMB will include the replication factor here. We should understand that RF means No. of copies of buckets that we have on the disk. Though these are not searchable copies and so might consume a little less space than searchable copies (which also includes tsidx files). But I guess the question is not ablout less or more space here.
So the answer is yes, "sizeOnDiskMB" will include the replicated copies of data as well.

Let me know if this answers you by marking this as answer and upvoting.
Thanks

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Recap | Agentic Operations Start with Context: Build the Right Data Foundation

Agentic Operations Start with Context: Build the Right Data Foundation   By Courtney Wright, Product Marketing ...

Recap | Assisted, Augmented or Agentic? Choose Your Splunk Starting Point

Assisted, Augmented or Agentic? Choose Your Splunk Starting Point   By Courtney Wright, Product Marketing ...

Session 2 | Beyond the Thread: Operationalizing AI with Confidence

Session 2   Beyond the Thread: Operationalizing AI with Confidence    The true power of the Cisco Data Fabric ...