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

jordanp98 avatar image
jordanp98 asked Erick Ramirez answered

How do I find the time taken by indexing reload operation?

When i start reloading of core using dsetool command reindexing starts and run in background and we can check progress using core_reindexing_status option in dsetool.

But for some reasons, i want to find out starting time of reload operation and the total time taken by this operation is there any way to find this information?

dse version : 6.7.4

dsesearch
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

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

When you kick off the indexing command, it creates entries in the DSE logs indicating when it started and when it finished.

Here are sample log entries that shows when the reload was requested and when it completed:

INFO  [mainIOThread-2] 2021-02-10 22:45:15,376  SolrCoreResourceManager.java:408 - Reloading core: contacts.users
...
INFO  [mainIOThread-2] 2021-02-10 22:45:15,812  AbstractSolrSecondaryIndex.java:308 - Getting initialization task for index 'contacts.users' in mode NORMAL with bootstrap state COMPLETED...
INFO  [mainIOThread-2] 2021-02-10 22:45:15,812  AbstractSolrSecondaryIndex.java:997 - Index 'contacts.users' initialized. Unblocking any pending invalidation...

If you specified reindex=true, log entries look like this:

INFO  [mainIOThread-2] 2021-02-10 22:51:02,586  SolrCoreResourceManager.java:494 - Reindex core: contacts.users
INFO  [SolrSecondaryIndex contacts.users index reloader.] 2021-02-10 22:51:02,587  ReindexRequestsConsumer.java:50 - Will now run reindexing task 1 of Solr core contacts.users with deleteAll=true
...
INFO  [SolrSecondaryIndex contacts.users index reloader.] 2021-02-10 22:51:02,741  AbstractSolrSecondaryIndex.java:1630 - Finished reindexing Solr core 'contacts.users'.
INFO  [SolrSecondaryIndex contacts.users index reloader.] 2021-02-10 22:51:02,741  ReindexRequestsConsumer.java:55 - Completed reindexing task 1 of Solr core contacts.users

You should then be able to workout from the timestamps how long it took to reindex your data. Cheers!

Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

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