Do you see difference when tracing the selects?
2017-04-17 13:36 GMT+02:00 Eren Yilmaz <eren.yil...@sebit.com.tr>:
> Application tables use LeveledCompactionStrategy. At first, counter tables
> were created by default SizeTieredCompactionStrategy, but we changed them
> to LeveledCompactionStrategy then.
>
>
>
> compaction = { 'class' :
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy',
> 'sstable_size_in_mb' : 512 }
>
>
>
> *From:* benjamin roth [mailto:brs...@gmail.com]
> *Sent:* Monday, April 17, 2017 12:12 PM
> *To:* user@cassandra.apache.org
> *Subject:* Re: Counter performance
>
>
>
> Do you have a different compaction strategy on the counter tables?
>
>
>
> 2017-04-17 10:07 GMT+02:00 Eren Yilmaz <eren.yil...@sebit.com.tr>:
>
> We are using Cassandra (3.7) counter tables in our application, and there
> are about 10 counter tables. The counter tables are in a separate keyspace
> with RF=3 (total 10 nodes). The tables are read-heavy, for each web request
> to the application, we read at least 20 counter values. The counter reads
> are very slow comparing to the other application data reads from cassandra,
> and sometimes the reads put extra heavy CPU load on some nodes.
>
>
>
> Are there any tips, or best practices for increasing the performance of
> counter tables?
>
>
>
