Re: Using the commit log for external synchronization

/commitlog_archiving.properties file. Large rows will bypass the commit log. A write commited to the commit log may still be considered a failure if CL nodes do not succeed. IMHO it's a better design to multiplex the data stream at the application level. Hope that helps. -

Re: [problem with OOM in nodes]

at this is outputting. >> As I can see in cfstats, compacted row maximum size: 386857368 ! Yes. Having rows in the 100's of MB is will cause problems. Doubly so if they are large super columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thel

Re: Varchar indexed column and IN(...)

ey_value means only the primary key field. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/09/2012, at 6:58 AM, Sergei Petrunia wrote: > Hello, > > Does CQL's IN(...) predicate have the same meaning as SQL's IN(...)?

Re: Correct model

Yup. (Multi get is just a convenience method, it explodes into multiple gets on the server side. ) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/09/2012, at 5:01 AM, "Hiller, Dean" wrote: > But the only advantage in

Re: Cassandra Messages Dropped

with lots-o-secondary indexes. > We had plenty of write I/O available. We also had free memory. I increased > the memtable_flush_writers to "2" and memtable_flush_queue_size to "8". We > haven't had any timeouts for a number of days now. Cool. Cheers -

Re: Secondary index loss on node restart

Can you contribute your experience to this ticket https://issues.apache.org/jira/browse/CASSANDRA-4670 ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/09/2012, at 6:22 AM, Michael Theroux wrote: > Hello, > > We have been

Re: [problem with OOM in nodes]

at helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/09/2012, at 5:14 PM, Denis Gabaydulin wrote: > On Sun, Sep 23, 2012 at 10:41 PM, aaron morton > wrote: >> /var/log/cassandra$ cat system.log | grep "Compacting large"

Re: Cassandra failures while moving token

ch node Try nodetool getendpoints- Print the end points that owns the key It wont tell you how a particular query worked, but it will say where a row should be. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/09/2012, at 9:39

Re: compression

Check the logs on nodes 2 and 3 to see if the scrub started. The logs on 1 will be a good help with that. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/09/2012, at 10:31 PM, Tamar Fraenkel wrote: > Hi! > I ran > UPDA

Re: downgrade from 1.1.4 to 1.0.X

I'd suggest contacting DS either through their support forums or directly via email. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 12:53 AM, Arend-Jan Wijtzes wrote: > On Thu, Sep 20, 2012 at 10:13:49AM +1200, a

Re: Understanding Thread Pools

The are thrift connection threads. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 1:32 AM, rohit bhatia wrote: > Hi > > What are "pool-2-thread-*" threads. Someone mentioned "Client > Conne

Re: Prevent queries from OOM nodes

Can you provide some information on the queries and the size of the data they traversed ? The default maximum size for a single thrift message is 16MB, was it larger than that ? https://github.com/apache/cassandra/blob/trunk/conf/cassandra.yaml#L375 Cheers - Aaron Morton

Re: performance for different kinds of row keys

et a row by row key. So this question only applied to the non composite key. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 9:34 AM, Marcelo Elias Del Valle wrote: > Suppose two cases: > I have a Cassandra colum

Re: Cassandra compression not working?

Nothing jumps out. Are you able to reproduce the fault on a test node ? There were some schema change problems in the early 1.1X releases. Did you enable compression via a schema change ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re:

That looks right to me. btw, most people use CLI or CQL scripts to manage the schema Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 7:59 PM, Manu Zhang wrote: > Is there an example to update column family add

Re: a node stays in joining

> > But the Load keeps on increasing. Sounds like the nodes are / were sending it data. nodetool netstats will show you what's going on. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 10:22 PM, Satoshi Ya

Re: The compaction task cannot delete sstables which are used in a repair session

it's running low. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/09/2012, at 11:56 PM, Rene Kochen wrote: > Is this a bug? I'm using Cassandra 1.0.11: > > INFO 13:45:43,750 Compacting > [SSTableReader(path='

Re: Running repair negatively impacts read performance?

, could you take a look at cfhistograms ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/09/2012, at 3:05 AM, Charles Brophy wrote: > Hey guys, > > I've begun to notice that read operations take a performance nose-d

Re:

Set the caching strategy for the CF to be ROWS_ONLY. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/09/2012, at 2:18 PM, Manu Zhang wrote: > The DEFAULT_CACHING_STRATEGY is Caching.KEYS_ONLY but even configuring row > cache s

Re: Prevent queries from OOM nodes

> CQL will read everything into List to make latter a count. From 1.0 onwards count paginated reading the columns. What version are you on ? https://issues.apache.org/jira/browse/CASSANDRA-2894 Cheers ----- Aaron Morton Freelance Developer @aaronmorton h

Re: Truncate causing subsequent timeout on KeyIterator?

Nothing jumps out. Turn the cassandra logging up to DEBUG and take a look at the cassandra logs. Your read will be logged in a [ReadStage-*] thread. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/09/2012, at 6:13 AM

Re:

> takes me around 7s now. My experiment is done on a single node. > > On Thu, Sep 27, 2012 at 6:00 AM, aaron morton wrote: > Set the caching strategy for the CF to be ROWS_ONLY. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorto

Re: cassandra key cache question

I had a quick look at the code (1.1X) and could not see a facility to purge dropped cf's from key or row caches. Could you create a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickl

Re: any ideas on what these mean

s versions it's in a different CF in the same KS. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/09/2012, at 4:04 AM, "Hiller, Dean" wrote: > We were consistently getting this exception over and over as we put data into

Re: pig and widerows

That looks like it may be a bug, can you create a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/09/2012, at 7:50 AM, William Oberman wrote: > I don't want to s

Re: How to stop streaming

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/09/2012, at 4:02 PM, Senthilvel Rangaswamy wrote: > Hello, > > We started a repair on one of our nodes without the -pr option. That started > a series > of repair on all ranges and we see a ton of str

Re: Remove node from cluster and have it run as a single node cluster by itself

> The other nodes may be trying to connect to it - it may be listed as a > seed node on the other machines? The other nodes will be looking for it. Change the Cluster Name in the yaml file. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.c

Re: Data Modeling: Comments with Voting

, and then write the updated leader board to cassandra. Alternatively if you have a small number of comments for a post just read all the votes and sort them as part of the read. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/09/2012

Re: Prevent queries from OOM nodes

> It's not about columns, it's about rows, see example statement. My bad, misread the CQL. My jira search fu is poor, but I could not find an open ticket for paging row counts. Could you create one ? https://issues.apache.org/jira/browse/CASSANDRA Cheers -----

Re: Cassandra vs Couchbase benchmarks

"you decide who is a winner" LOLS Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2/10/2012, at 4:48 AM, horschi wrote: > Hi Andy, > > things I find odd: > > - Replicacount=1 for mongo and couchdb. How is that a

Re: How to stop streaming

> Also, how do I lookup the current value of the setstreamthroughput. The default / startup value is specified in the yaml file. If you need to check the running value it is on the StorageProxy MBean, accessed using JConsole or some other JMX thingy. Cheers ----- Aaron Mor

Re: cql3 and cli composites columns

mic CF. Hope that helps. ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2/10/2012, at 10:37 PM, Cyril Auburtin wrote: > I wanted to know why the highlighted sections below are printed differently, > the 2 column families are the same >

Re: Read latency issue

, may be confusing secondary index reads here). Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 3/10/2012, at 2:17 AM, Roshni Rajagopal wrote: > Arindam, > > Did you also try the cassandra stress tool & compare results? > >

Re: Persistent connection among nodes to communicate and redirect request

QPS What CL ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 3/10/2012, at 4:57 AM, "Hiller, Dean" wrote: > Can you just use netstat and dig into the process id and do a ps -ef | > grep to clear up all the confusion. Do

Re: Getting serialized Rows from CommitLogSegment file

> > Do you know where (which e-mail thread) was it discussed? I would like to > know a little further about it. http://www.mail-archive.com/user@cassandra.apache.org/msg25033.html Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On

Re: RandomPartitioner and the token limits

AFAIK in the code the minimum exclusive value token is -1, so as a signed integer the maxmium value is 2**127 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 4/10/2012, at 3:19 AM, Carlos Pérez Miguel wrote: > Hello, > > Re

Re: Regarding Row Cache configuration and non-heap memory

e size of the heap in 1.1X. The default settings max out of 4G. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 4/10/2012, at 3:21 PM, Ananth Gundabattula wrote: > Hello, > > I have configured cassandra 1.1.4 to use row cache of

Re: Importing sstable with Composite key? (without is working)

Not sure why you have two different definitions for the bars2 CF. You will need to create SSTable's that match the schema cassandra has. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/10/2012, at 7:15 AM, T Akhayo wrote: &

Re: Why data is not even distributed.

This is an issue with using the BOP. If you are just starting out stick with the Random Partitioner. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/10/2012, at 10:33 AM, Andrey Ilinykh wrote: > It was my first thought. > Then

Re: Query over secondary indexes

h node is involved. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/10/2012, at 10:20 PM, Vivek Mishra wrote: > Thanks Rishabh. But i want to search over duplicate columns only. > > -Vivek > > On Fri, Oct 5, 2012 at

Re: Question regarding hinted handoffs and restoring backup in cluster

keeping the hints in place is ok. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/10/2012, at 12:30 AM, Fredrik wrote: > When restoring a backup for the entire cluster my understanding is that you > must shutdown the

Re: rolling restart after gc_grace change

ge their tombstone (essentially a hard delete), while one replica keeps the original value. The result is data returning from the dead. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/10/2012, at 2:54 AM, Oleg Dulin wrote: &

Re: question about where clause of CQL update statement

locked = 'false' ? Not sure that's supported. But I'm not sure this is the right sort of error. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/10/2012, at 11:30 AM, John Sanda wrote: > I am using CQL 3 and tr

Re: Text searches and free form queries

> It works pretty fast. Cool. Just keep an eye out for how big the lucene token row gets. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/10/2012, at 2:57 AM, Oleg Dulin wrote: > So, what I ended up doing is this -- > >

Re: Cassandra 1.1.4 performance issue

d correlate with compaction or repair times ? The node is not waiting on IO and is using all the available CPU, which is a good thing. Have you seen an increase in latency ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/10/2012, at 1

Re: Problem while streaming SSTables with BulkOutputFormat

gStreamReader.read(IncomingStreamReader.java:98) > at > org.apache.cassandra.net.IncomingTcpConnection.stream(IncomingTcpConnection.java:182) > at > org.apache.cassandra.net.IncomingTcpConnection.run(IncomingTcpConnection.java:78) > > > Does anyone know what caused these errors? > > Thank you for your help. > Regards, > Ralph - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com

Re: READ messages dropped

mpaction, or simply too many requests. it also a good idea to take a look at iostat to see if the disk is keeping up. Hope that helps ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 9/10/2012, at 9:08 AM, Tamar Fraenkel wrote: > Hi! >

Re: UnreachableNodes

node that sees 9.109 as down. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/10/2012, at 8:45 PM, Rene Kochen wrote: > I have a four node EC2 cluster. > > Three machines show via nodetool ring that all machines are UP. >

Re: Cassandra nodes loaded unequally

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/10/2012, at 12:22 PM, Ben Kaehne wrote: > Nothing unusual. > > All servers are exactly the same. Nothing unusual in the log files. Is there > any level of logging that I should b

Re: run repair on each node or every R nodes?

were not repaired. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/10/2012, at 5:15 AM, Andrey Ilinykh wrote: >> >> In my mind it does make sense, and what you're saying is correct. But I read >> that it was

Re: Missing non composite column

we do not store the values with ":" separators. Any idiomatic API will take care of parsing the raw wire format, see the pycassa example here... http://pycassa.github.com/pycassa/assorted/composite_types.html Cheers - Aaron Morton Freelance Developer @aaronmorton http://

Re: Astyanax empty column check

sk, but be made up of non-live columns. These are a combination of expired TTL columns and columns overwritten by (row or column) tombstones. Eventually a row with 0 live columns, with >0 non live columns will be compacted and purged from disk. Hope that helps. - Aaron Mor

Re: RF update

shold to 0 via schema or nodetool * disabling durable_writes to disable the commit log during the bulk load. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 17/10/2012, at 11:55 PM, Matthias Broecheler wrote: > Follow up question:

Re: how to get column type?

client for in your chosen language and take a look if you need programatic access. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 1:40 AM, "Hiller, Dean" wrote: > This is specifically why Cassandra and eve

Re: replaced node keeps returning in gossip

I *thought* that remove_token would remove the old IP from the ring. Can you post the output from nodetool gossipinfo from the 128.197 node ? Thanks --------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 2:44 AM, Thomas van Neerijnen wrote: &

Re: UnreachableNodes

Cool. If you get it again grab nodetool gossipinfo from a few machines. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 3:32 AM, Rene Kochen wrote: > Thanks Aaron, > > Telnet works (in both directions). >

Re: Why my Cassandra is compacting like mad

that you are running 1.1.5 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 4:36 AM, Bryan wrote: > I think I am seeing the same issue, but it doesn't seem to be related to the > schema_columns. I understand tha

Re: What does ReadRepair exactly do?

. RowRepairResolve.scheduleRepairs() works out the delta for each node by calling ColumnFamily.diff(). The delta is then sent to the appropriate node. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 6:33 AM, Markus

Re: Hinted Handoff runs every ten minutes

I *think* this may be ghost rows which have not being compacted. How many SSTables are on disk for the HintedHandoff CF ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/10/2012, at 7:16 AM, David Daeschler wrote: > Hi St

Re: Compound primary key: Insert after delete

Yes AFAIK. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 12:15 AM, Vivek Mishra wrote: > Hi, > Is it possible to reuse same compound primary key after delete? I guess it > works fine for non composite keys. > > -Vivek

Re: DELETE query failing in CQL 3.0

Can you paste the table definition ? Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 5:53 AM, "Ryabin, Thomas" wrote: > I have a column family called “books”, and am trying to delete all rows where > the “

Re: constant CMS GC using CPU time

ces, like compaction, repair and throughput. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/10/2012, at 6:59 AM, Bryan Talbot wrote: > ok, let me try asking the question a different way ... > > How does cassandra

Re: find smallest counter

rations. You will need to iterate the columns and find the smallest value. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/10/2012, at 2:28 PM, Paul Loy wrote: > I have a set of categories. In these categories I want to add groups

Re: Compound primary key: Insert after delete

How is it not working ? Can you replicate the problem withe the CLI ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/10/2012, at 7:17 PM, Vivek Mishra wrote: > code attached. Somehow it is not working with 1.1.5. > > -Vive

Re: Log client

AFAIK IP not logged. If you want to check the connection try lsof Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/10/2012, at 9:34 PM, Jean Paul Adant wrote: > Hi all, > > How can I log on server the IP of every connecti

Re: Row caching memory usage in Cassandra 1.0.x

#x27;s own row cache, so tuning must be done per CF. ) Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 3:35 AM, Josh wrote: > Hi, I'm hoping to get some help on how to help tune our 1.0.x cluster w.r.t. > row

Re: constant CMS GC using CPU time

d fp chance is known? See o.a.c.utils.BloomFilter.getFilter() in the code This http://hur.st/bloomfilter appears to give similar results. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 4:38 AM, Bryan Talbot wrote: >

Re: What does ReadRepair exactly do?

. ArrayBackedSortedColumns, will call reconcile() on the IColumn if they need to. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 4:45 AM, Manu Zhang wrote: > Is it through filter.collateColumns(resolved, iters, Integer.MIN_VA

Re: tuning for read performance

ent compaction methods. But don't go > crazy creating 1000's of CF's either. +1 25 ms read latency is high. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 9:06 AM, Aaron Turner wrote: > On Mon,

Re: Strange row expiration behavior

had not run so the tombstones stayed on disk. In the second the major compaction purged expired tombstones. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 2:49 PM, Stephen Mullins wrote: > Hello, I'm s

Re: nodetool cleanup

d. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 6:42 PM, Will @ SOHO wrote: > On 10/23/2012 01:25 AM, Peter Schuller wrote: >> >> On Oct 22, 2012 11:54 AM, "B. Todd Burruss" wrote: >> > >> > doe

Re: How to change the seed node Cassandra 1.0.11

Just change the yaml and restart. The seed list is not persisted i the System KS (like the token assignment). I would suggest running 2 or 3 seeds in your cluster, even if you only have 3 nodes. Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: Node Dead/Up

say by being overloaded to in long ParNew GC pauses. * Problems with the tubes used to connect the nodes. (It's probably the first one.) Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/10/2012, at 8:19 PM, Jason Wee wrote:

Re: Strange row expiration behavior

ve to manually delete empty rows after the columns expire. . Rows are automatically purged when all columns are purged. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/10/2012, at 3:05 AM, Stephen Mullins wrote: > Thanks Aaron, my r

Re: Node Dead/Up

m see http://spyced.blogspot.co.nz/2010/01/linux-performance-basics.html Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/10/2012, at 1:27 PM, Jason Hill wrote: > thanks for the replies. > > I'll check the load on the node that is repo

Re: compression

Can you try restarting the node ? That would reload the CF Meta data and reset the compaction settings. Sorry that's not very helpful but it's all I can think of for now. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/10/2

Re: Hinted Handoff runs every ten minutes

Thanks. I thought it had been addressed so before but couldn't find the ticket. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/10/2012, at 12:56 AM, Brandon Williams wrote: > On Sun, Oct 21, 2012 at 6:44 PM, aaron morto

Re: Hinted Handoff storage inflation

ore. You can adjust how long hints a collected for with max_hint_window_in_ms in the yaml file. How long did the test run for ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/10/2012, at 11:26 AM, Mattias Larsson wrote: >

Re: What does ReadRepair exactly do?

ead Repair, Hinted Handoff or nodetool repair will repair the inconsistency. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/10/2012, at 4:39 AM, "Hiller, Dean" wrote: >> Thanks Zhang. But, this again seems

Re: constant CMS GC using CPU time

> Regarding memory usage after a repair ... Are the merkle trees kept around? > They should not be. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/10/2012, at 4:51 PM, B. Todd Burruss wrote: > Regarding memory usage after

Re: constant CMS GC using CPU time

app does which may impact things, and look for poorly performing queries. Finally this book is a good reference on Java GC http://amzn.com/0137142528 For my understanding what was the average row size for the 400 million keys ? Hope that helps. - Aaron Morton Freel

Re: constant CMS GC using CPU time

hour and set gc_grace_seconds to 0 so > the number of rows and data dropped to a level it can handle. Cool. Sorry if took so long to get there. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/10/2012, at 8:08 AM, Bryan Talbot wrote:

Re: What does ReadRepair exactly do?

lly reach a state where reads at any CL return the last write. They are not used to ensure strong consistency when R + W > N. You could turn those things off and R + W > N would still work. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelast

Re: how to implement a client with off-heap memory

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/10/2012, at 4:59 PM, Manu Zhang wrote: > Hi all, > > I've been writing a client on Cassandra Thrift API. The client will read > almost 1G of data into JVM heap and thus its performance suffers from

Re: High bandwidth usage between datacenters for cluster

an issue for us, but at times we are writing > approximately 1MB a sec of data, and seeing a corresponding 3MB of traffic > across the WAN to all the Cassandra DR servers. Can you break the traffic down by port and direction ? Cheers ----- Aaron Morton Freelance Develope

Re: Roadmap/Changelog?

%3Aroadmap-panel Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/10/2012, at 11:56 AM, Timmy Turner wrote: > Hi everyone, > > I wrote a library/extension for Cassandra 0.8 a while back, and would > like to update it to the cur

Re: Hinted Handoff storage inflation

a smaller test case ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/10/2012, at 7:56 AM, Mattias Larsson wrote: > > On Oct 24, 2012, at 6:05 PM, aaron morton wrote: > >> Hints store the columns, row key, KS name and CF id(s

Re: compression

ers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/10/2012, at 9:12 PM, Tamar Fraenkel wrote: > Hi! > Thanks Aaron! > Today I restarted Cassandra on that node and ran scrub again, now it is fine. > > I am worried though that if

Re: CQL3: Unknown property 'comparator'?

the name of a column is "click_time". Previously the label was "column1". > It's now impossible (within CQL) to add new > (non-primary-key) columns only for individual rows implicitly with > DML-queries (insert/update)?. Is your use case covered in the articl

Re: CQL3: Unknown property 'comparator'?

column families obviously) are now > impossible within CQL, that I can document in the project as the > reason for the changes. AFAIK to be "schema free" you use the "row-column-value" model. While this looks like many rows it is a single store engine row. Cheers

Re: Throughput decreases as latency increases with YCSB

048 Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/10/2012, at 9:10 PM, Terje Marthinussen wrote: > Check how many concurrent real requests you have vs size of thread pools. > > Regards, > Terje > > On 30 Oct 2012, a

Re: idea drive layout - 4 drives + RAID question

assandra column families on different drives by just > setting up symlinks to the individual folders. There are some features coming in 1.2 that make using a JBOD setup easier. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/10/2012,

Re: Multiple counters value after restart

and refreshes > every sec) shows me 4 different values. 2 of them repeatedly (5000 and 4000) > and the 2 other some rare times (5500 and 3800) Are you saying that a particular counter column is giving different values for different reads ? What CL are you using ? Cheers ---

Re: Benifits by adding nodes to the cluster

d to move every node. But if you have 10 nodes you probably don't want to scale up by 3, I would guess 5 or 10. Scaling is not something you want to do every day. How easy the process is depends on the level of automation in your environment. For example Ops Centre can automate rebalancing nod

Re: idea drive layout - 4 drives + RAID question

on the OS volume, it would be competing with C* reads, Memtable flushing, compacting and repairing on the data volume. The only way to be sure is to test both setups. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/10/2012, at 1:11

Re: Query slowly using enterprise Cassandra

You will have better luck with Data Stax Enterprise questions on their support forums: http://www.datastax.com/support-forums/ Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/10/2012, at 4:17 PM, dong.yajun wrote: > hi l

Re: repair, compaction, and tombstone rows

tps://issues.apache.org/jira/browse/CASSANDRA and describe the problem ? Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/11/2012, at 8:04 AM, Bryan Talbot wrote: > I've been experiencing a behavior that is undesirable and it seems

Re: Benifits by adding nodes to the cluster

I've not run it myself, but upgrading is part of the design. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/11/2012, at 10:43 AM, Wei Zhu wrote: > I heard about virtual nodes. But it doesn't come out until 1.2.

Re: Multiple counters value after restart

e... I was asking to understand how you did the upgrade. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/11/2012, at 11:39 AM, Alain RODRIGUEZ wrote: > "What version of cassandra are you using ?" > > 1.1.2 > >

Re: Connecting to cassandra.

> I am not sure of the impact of setting it to this loopback address. Fine for testing purposes with one node. If you have more than you you will want to make it the same as the listen_address. Cheers ----- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle

<    1   2   3   4   5   6   7   8   9   10   >