Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

a.gheshlaghy_177282 avatar image
a.gheshlaghy_177282 asked ·

Why do secondary indexes extend the time it takes to bootstrap a node?

Hi,

Having secondary index in table seems to extend adding node duration significantly, what parameters affect this? is there any workaround or tuning for it?

dseindex
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

The factors with affect the amount of time it takes to index data on a bootstrapping node are:

  • number of secondary indexes
  • amount of data to be indexed
  • disk IO throughput
  • to a lesser extent CPU and memory utilisation

Indexing is a normal part of the operation of Cassandra. If the nodes are dense, have a lot of data, and the disks are IO-bound, there is nothing you can do but wait. The indexing needs to complete before the node can accept requests. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.