cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: does secondary index get created(rebuilt?) every time Cassandra restarts?
Date Fri, 20 Jul 2012 09:25:49 GMT
>  INFO [OptionalTasks:1] 2012-07-18 14:05:27,648 SecondaryIndexManager.java (line 183)
Creating new index : ColumnDefinition{name=74696d657374616d70, validator=org.apache.cassandra.db.marshal.DateType,
index_type=KEYS, index_name='MtsTrackingData_timestamp_idx'}
Is the system reading the index meta data. 

Do you see any INFO level messages with "Submitting index build" ?

cheers

-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 20/07/2012, at 5:52 AM, Feng Qu wrote:

> We have a CF with 11 secondary indexes (don't ask me why) and I noticed restarting cassandra
takes much longer time comparing to other clusters without secondary indexes. In system.log
I see 20 mins pause on building index. 
> 
> this example shows a 12 mins gap.
>  INFO [SSTableBatchOpen:13] 2012-07-18 13:53:51,556 SSTableReader.java (line 153) Opening
/data/cassandra/data/mobileks/MtsTrackingData-hc-5744 (1950145442 bytes)
>  INFO [SSTableBatchOpen:12] 2012-07-18 13:53:51,556 SSTableReader.java (line 153) Opening
/data/cassandra/data/mobileks/MtsTrackingData-hc-5197 (12551211807 bytes)
>  INFO [OptionalTasks:1] 2012-07-18 14:05:27,648 SecondaryIndexManager.java (line 183)
Creating new index : ColumnDefinition{name=74696d657374616d70, validator=org.apache.cassandra.db.marshal.DateType,
index_type=KEYS, index_name='MtsTrackingData_timestamp_idx'}
>  INFO [SSTableBatchOpen:2] 2012-07-18 14:05:27,673 SSTableReader.java (line 153) Opening
/data/cassandra/data/mobileks/MtsTrackingData.MtsTrackingData_timestamp_idx-hc-4354 (64493843
bytes)
>  INFO [SSTableBatchOpen:1] 2012-07-18 14:05:27,673 SSTableReader.java (line 153) Opening
/data/cassandra/data/mobileks/MtsTrackingData.MtsTrackingData_timestamp_idx-hc-4344 (258674041
bytes)
>  INFO [SSTableBatchOpen:5] 2012-07-18 14:05:27,673 SSTableReader.java (line 153) Opening
/data/cassandra/data/mobileks/MtsTrackingData.MtsTrackingData_timestamp_idx-hc-1826 (3397211685
bytes)
> 
> Is this by design? Why it has to be created during start up?
>  
> Feng Qu


Mime
View raw message