7; and key2 = 'test2' and key3 = 'test3';" => Bad Request: Unknown
identifier value2 (as expected I guess)
I want to make a counter CF with composite keys and a lot of counters using
this pattern "20130306#event" or "(20130306, event)", not sure
Ah, I'ts with many columns, not rows. I use this in cql 2-3 create table cnt
(key text PRIMARY KEY, y2003 counter, y2004 counter);it says this is not a
counter column family, and if I try to use
default_validation_class=CounterType,it says this is not a valid keyword.What
I'm supposed to type
I got it now.
From: mateus.ffrei...@hotmail.com
To: user@cassandra.apache.org
Subject: RE: Can I create a counter column family with many rows in 1.1.10?
Date: Wed, 6 Mar 2013 08:42:37 -0300
Ah, I'ts with many columns, not rows. I use this in cql 2-3 create table cnt
(key text PRIMARY KEY,
Wow, that's quite new... Threadjack to ask how to unsubscribe, amazing.
Help yourself: https://www.google.com/search?q=unsubscribe+cassandra
Any of the first results should help you. Goodbye !
2013/3/6 deepansh jain
> how to unsubscribe from mailing list
>
>
> On Wed, Mar 6, 2013 at 1:06 PM,
I ran a pretty solid QA test(cleaned data from scratch) on version 1.2.2
My test was as so
1. Start up 4 node cassandra cluster
2. Populate with initial test data (no other data is added to system after
this point!!!)
3. Run nodetool drain on every node(move stuff from commit log to sstabl
http://www.slideshare.net/edwardcapriolo/cassandra-as-memcache
Read at ONE.
READ_REPAIR_CHANCE as low as possible.
Use short TTL and short GC_GRACE.
Make the in memory memtable size as high as possible to avoid flushing and
compacting.
Optionally turn off commit log.
You can use cassandra like
est: line
> 1:29 no viable alternative at input 'value2'
>
> I also tried:
> "update composite_counter set value2 = value2 + 5 where aid = '1' and key1 =
> 'test1' and key2 = 'test2' and key3 = 'test3';" => Bad Request: Unk
> 15. Size of nreldata is now 220K ….it has exploded in size!!
This may be explained by fragmentation in the sstables, which compaction would
eventually resolve.
During repair the data came from multiple nodes and created multiple sstables
for each CF. Streaming copies part of an SSTable on
Thanks for the great info, I will give it a go.
1 question though, my false positive rate and number of rows is not changing so
why is the bloomfilter bigger? Or do you mean bloomfilter is not based on
number of rows int he table but based on how the rows are spread through the
sstable files?
Thanks guys, this is what I was looking for.
@Edward. I definitely like crazy ideas ;), I think the only issue here is that
C* is a disk space hug, so not sure if that would be feasible since free RAM is
not as abundant as disk. BTW, I watched your presentation, are you guys still
using C* as i
If your writing much more data then RAM cassandra will not work as fast as
memcache. Cassandra is not magical, if all of your data fits in memory it
is going to be fast, if most of your data fits in memory it can still be
fast. However if you plan on having much more data then disk you need to
thin
I think the dataset should fit in memory easily. The main purpose of this would
be as a store for an API rate limiting/accounting system. I think ebay guys are
using C* too for the same reason. Initially we were thinking of using Hazelcast
or memcahed. But Hazelcast (at least the community editi
It also depends on you SLA, it should work for 99% of the time. But one
GC/flush/compact could screw things up big time if you have tight SLA.
-Wei
From: Drew Kutcharian
To: user@cassandra.apache.org
Sent: Wednesday, March 6, 2013 9:32 AM
Subject: Re: Cassand
Hi - Is there a way to increase the hinted handoff throughput ? I am seeing
around 8Mb/s (bits).
Thanks,
Kanwar
Got the param. thanks
From: Kanwar Sangha [mailto:kan...@mavenir.com]
Sent: 06 March 2013 13:50
To: user@cassandra.apache.org
Subject: Hinted handoff
Hi - Is there a way to increase the hinted handoff throughput ? I am seeing
around 8Mb/s (bits).
Thanks,
Kanwar
After trying to bump up the "hinted_handoff_throttle_in_kb" to 1G/b per sec, It
still does not go above 25Mb/s. Is there a limitation ?
From: Kanwar Sangha [mailto:kan...@mavenir.com]
Sent: 06 March 2013 14:41
To: user@cassandra.apache.org
Subject: RE: Hinted handoff
Got the param. thanks
Fr
Is this correct ?
I have Raid 0 setup for 16 TB across 8 disks. Each disk is 7.2kRPM with IOPS of
80 per disk. Data is ~9.5 TB
So 4K * 80 * 9.5 = 3040 KB ~ 23.75 Mb/s.
So basically I am limited at the disk rather than the n/w
From: Kanwar Sangha [mailto:kan...@mavenir.com]
Sent: 06 March 2013
Actually I didn't concurrent update the same records, because I first
create it, then search it, then delete it. The version conflict solved
failed, due to delete local time stamp is earlier then create local time
stamp.
2013/3/6 aaron morton
> Otherwise, it means the version conflict solving s
I have 4 Nodes, and I'd like to store all keys starting with 'a' on node 1, 'b'
on 2, and so on.My keys just start with a letter and numbers follow, like
'a150', 'b1','c32000'.I've set the initial tokens to 61ff, 62ff ,63ff, 64ff
.This does not seem to be the correct way.Thanks.
Check the IO utilisation using iostat
You *really* should not need to make HH run faster, if you do there is some
thing bad going on. I would consider dropping the hints and running repair.
> Data is ~9.5 TB
Do you have 9.5TB on a single node ?
In the normal case it's best to have around 300 t
> but based on how the rows are spread through the sstable files?
It's per sstable.
Cheers
-
Aaron Morton
Freelance Cassandra Developer
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 6/03/2013, at 8:51 AM, "Hiller, Dean" wrote:
> Thanks for the great info, I will gi
Hi,
My version is 1.1.7
Our use case is : we have a index columnfamily to record how many resource
is stored for a user. The number might vary from tens to millions.
We provide a feature to let user to delete resource according prefix.
we found some cassandra will OOM after some period. The
> I have 4 Nodes, and I'd like to store all keys starting with 'a' on node 1,
> 'b' on 2, and so on.
Can I ask why ?
In general you *really* dont want to use the ByteOrderedPartitioner. If you are
starting out, you will have a happier time if you start with the Random
Partitioner.
If you wan
hmm.. did you managed to take a look using nodetool tpstats? That may give
you indication further..
Jason
On Thu, Mar 7, 2013 at 1:56 PM, 金剑 wrote:
> Hi,
>
> My version is 1.1.7
>
> Our use case is : we have a index columnfamily to record how many resource
> is stored for a user. The number m
Hi all,
I'm experiencing strange latency spikes when writing and trying to figure out
what could cause them.
My setup:
- 3 nodes, writing at CL.ONE using Hector client, no reads
- Writing simultaneously to 3 CFs, inserts with 25h TTL, no deletes, no
updates, RF 3
- 2 CFs have small data (row
25 matches
Mail list logo
