[ https://issues.apache.org/jira/browse/CASSANDRA-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13020109#comment-13020109 ]
Jason Haruska commented on CASSANDRA-2470: ------------------------------------------ This bug also affects adding new nodes to a cluster. In our case, the data streaming finishes in 20-30 minutes with the secondary indexes taking 3-4 hours to build. > Secondary Indexes Build Very Slowly > ----------------------------------- > > Key: CASSANDRA-2470 > URL: https://issues.apache.org/jira/browse/CASSANDRA-2470 > Project: Cassandra > Issue Type: Improvement > Reporter: Benjamin Coverston > Labels: repair, secondary_index > > While running repair I noticed that the time it took to run was easily > dominated by building the secondary indexes. They currently build at a rate > of < 200KB/Second. This means that indexing a 500MB file takes nearly an hour > to index the file. > Because this happens on the compaction thread it also causes repair to back > up in general, which for very active systems is a very bad thing. > I suggest we look at it in the hope that we can improve the rate in which we > build the indexes by an order of magnitude. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira