Gathering Stats In Couchbase

Couchbase Server
1

Hi Team,

In Couchbase 7.1 there is option to choose to use Cost based Optimizer. As we know in RDBMS technology with out stats collection the optimizer will not choose a good plan in case CBO. So our concern is how to gather stats for the buckets is it automatic or we need to write some scripts to do it. What are the best practices while gather stats.

Please share us any documentation link or blog reference to follow the same.

Thanks,
Debasis

2

https://www.google.com/search?q=couchbase+cost+base+optimizer+statistics

Both the first and second hits.

3

Thanks @mreiche for response. I just glanced those two links and did not found anywhere that CB engine gather stats automatically for buckets i:e we need to run the stats manually. Please correct me if I am wrong.

Thanks,
Debasis

4

Follow the procedure described in the documentation.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.