[
https://issues.apache.org/jira/browse/CASSANDRA-13027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne resolved CASSANDRA-13027.
------------------------------------------
Resolution: Invalid
I'm sorry but JIRA is for tracking bugs and features, it isn't a user forum.
Please send your question on the user mailing list (see
http://cassandra.apache.org/doc/latest/contactus.html for details).
> Questions on compaction process
> -------------------------------
>
> Key: CASSANDRA-13027
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13027
> Project: Cassandra
> Issue Type: Task
> Components: Compaction
> Environment: ubuntu, centos
> Reporter: Arvind Viswanathan
> Fix For: 2.2.5
>
>
> I have the following schema ( a raw table and index table to look up data
> from the raw table) and I notice the following problem:
> create table raw_table(
> key uuid PRIMARY KEY,
> value text) ;
> create table index_table_1(
> time int,
> index_field1 text,
> col1 text,
> value uuid); PRIMARY_KEY(int, text)
> My usage involves continuous writes( no updates, just new data with TTL of 48
> hrs) and very less reads. I use STCS. I noticed the reads to the raw_table
> are failing whereas the one to index tables where succeeding. I took a look
> at the compaction history of the different table and here is what I observe
> Raw table has low completedcompactions (from the nodetool compactionhistory)
> but high number of SSTable count (from nodetool cfstats), whereas the index
> table has lot of completed compactions and low SSTable count. I can
> understand that high SSTable count can lead to read failures, but I don't
> understand why the compactions are not able to complete as fast in the raw
> tables. The cassandra version I use is 2.2.5.
> Also what is the impact of compaction on append only tables?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
