Re: any way to get the #writes/second, reads per second

2013-05-14 Thread Tomàs Núnez
Yes, there isn't any place in the JMX with reads/second or writes/second, just CompletedTasks. I send this info to Graphite ( http://graphite.wikidot.com/) and use the "derivative" function to get reads/minute. Munin also does the trick (https://github.com/tcurdt/jmx2munin). But you can't do that w

Logging Cassandra queries

2013-05-17 Thread Tomàs Núnez
Hi! For quite time I've been having some unexpected loadavg in the cassandra servers. I suspect there are lots of uncontrolled queries to the cassandra servers causing this load, but the developers say that there are none, and the load is due to cassandra internal processes. Trying to get to the

Re: Logging Cassandra queries

2013-05-18 Thread Tomàs Núnez
> Cheers > > - > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 18/05/2013, at 4:00 AM, Tomàs Núnez wrote: > > Hi! > > For quite time I've been having some unexpe

Re: Logging Cassandra queries

2013-05-18 Thread Tomàs Núnez
there's nothing like that from what I could find. We had to > modify c* source (CassandraServer.java) to add this query logging to the > thrift codepath. > On May 18, 2013 3:20 PM, "Tomàs Núnez" wrote: > >> Yes, I read how to do that here, as well: >>

Alternate "major compaction"

2013-07-11 Thread Tomàs Núnez
Hi About a year ago, we did a major compaction in our cassandra cluster (a n00b mistake, I know), and since then we've had huge sstables that never get compacted, and we were condemned to repeat the major compaction process every once in a while (we are using SizeTieredCompaction strategy, and we'