DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


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.