Row cache and counters

2012-12-29 Thread André Cruz
Hello. I recently was having some timeout issues while updating counters and turned on row cache for that particular CF. This is its stats: Column Family: UserQuotas SSTable count: 3 Space used (live): 2687239 Space used (total): 26

Re: Row cache and counters

2012-12-29 Thread rohit bhatia
Reads during a write still occur during a counter increment with CL ONE, but that latency is not counted in the request latency for the write. Your local node write latency of 45 microseconds is pretty quick. what is your timeout and the write request latency you see. In our deployment we had some

Re: Row cache and counters

2012-12-29 Thread André Cruz
On 29/12/2012, at 16:59, rohit bhatia wrote: > Reads during a write still occur during a counter increment with CL ONE, but > that latency is not counted in the request latency for the write. Your local > node write latency of 45 microseconds is pretty quick. what is your timeout > and the wri

Column Family migration/tombstones

2012-12-29 Thread Mike
Hello, We are undergoing a change to our internal datamodel that will result in the eventual deletion of over a hundred million rows from a Cassandra column family. From what I understand, this will result in the generation of tombstones, which will be cleaned up during compaction, after gc_

Re: Row cache and counters

2012-12-29 Thread rohit bhatia
i assume u mean 8 seconds and not 8ms.. thats pretty huge to be caused by gc. Is there lot of load on your servers? You might also need to check for memory contention Regarding GC, since its parnew all u can really do is increase heap and young gen size, or modify tenuring rate. But that can't be

Re: Row cache and counters

2012-12-29 Thread Mohit Anchlia
Can you post gc settings? Also check logs and see what it says Also post how many writes and reads along with avg row size Sent from my iPhone On Dec 29, 2012, at 12:28 PM, rohit bhatia wrote: > i assume u mean 8 seconds and not 8ms.. > thats pretty huge to be caused by gc. Is there lot of lo

Create Keyspace failing in 1.2rc2 with syntax error?

2012-12-29 Thread Adam Venturella
When I create a keyspace with a SimpleStrategy as outlined here: https://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt CREATE KEYSPACE Test WITH strategy_class = SimpleStrategy AND strategy_options:replication_factor = 1; I receive the following error: Bad Re

Re: Create Keyspace failing in 1.2rc2 with syntax error?

2012-12-29 Thread Adam Venturella
Nevermind... help CREATE_KEYSPACE; works wonders.. CREATE KEYSPACE WITH replication = {'class':'SimpleStrategy', 'replication_factor':3}; =) On Sat, Dec 29, 2012 at 1:27 PM, Adam Venturella wrote: > When I create a keyspace with a SimpleStrategy as outlined here: > https://

Re: Create Keyspace failing in 1.2rc2 with syntax error?

2012-12-29 Thread Dave Brosius
the format has changed, check the help in cqlsh CREATE KEYSPACE Test WITH replication = {'class':'SimpleStrategy', 'replication_factor':1}; On 12/29/2012 04:27 PM, Adam Venturella wrote: When I create a keyspace with a SimpleStrategy as outlined here: https://cassandra.apache.org/doc/cql3/C