cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From benjamin roth <brs...@gmail.com>
Subject RE: Counter performance
Date Mon, 17 Apr 2017 14:43:57 GMT
You could enable a slow query log and then trace single queries couldn't
you?

Am 17.04.2017 16:31 schrieb "Eren Yilmaz" <Eren.Yilmaz@sebit.com.tr>:

I can’t trace selects on the application tables unfortunately. The
application is Usergrid, and it stores the data in binary. We have little
control over Usergrid-created data.



*From:* benjamin roth [mailto:brstgt@gmail.com]
*Sent:* Monday, April 17, 2017 4:12 PM

*To:* user@cassandra.apache.org
*Subject:* Re: Counter performance



Do you see difference when tracing the selects?



2017-04-17 13:36 GMT+02:00 Eren Yilmaz <Eren.Yilmaz@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:brstgt@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.Yilmaz@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?

Mime
View raw message