Hi Mikhail,
Thank you for pointing out. It is helpful.
Thanks,
Bhathiya
On Fri, Nov 8, 2013 at 1:18 PM, Mikhail Stepura wrote:
> Please take a look at https://issues.apache.org/jira/browse/CASSANDRA-6266for
> details
>
> -M
>
> "Bhathiya Jayasekara" wrote in message
> news:capt+24qd4e_+_6oc
Hello,
I'm facing OOM on reading key_cache
Cluster conf is as follows:
-6 machines which 8gb RAM each and three 150GB disks each
-default heap configuration
-deafult key cache configuration
-the biggest keyspace has abt 500GB size (RF: 2, so in fact there is
250GB of raw data).
After upgrading fir
Hi,
On 11/07/2013 05:18 AM, Aaron Morton wrote:
>> Class Name
>>| Shallow Heap | Retained Heap
>> --
Hey guys, I need to retrieve a list of distinct users based on their
activity datetime. How can I model a table to store that kind of
information?
The straightforward decision was this:
CREATE TABLE user_activity (user text primary key, ts timeuuid);
but it turned out it is impossible to do a se
You could try this:
CREATE TABLE user_activity (shard text, user text, ts timeuuid, primary key
(shard, ts));
select user, ts from user_activity where shard in ('00', '01', ...) order
by ts desc;
Grab each user and ts the first time you see that user.
Use as many shards as you think you need to
CREATE COLUMNFAMILY post (
KEY uuid,
author uuid,
blog uuid,
name text,
data text,
PRIMARY KEY ( KEY )
);
SELECT * FROM post WHERE blog IN (1,2) AND author=3 ALLOW FILTERING;
(don't look at fact numbers are not uuids :)
Error: IN predicates on non-primary-key columns (blog
How about something like using a time-range as the key (e.g an hour
depending on your update rate) and a composite (time:user) as the column
name
cheers
On Fri, Nov 8, 2013 at 10:45 PM, Laing, Michael
wrote:
> You could try this:
>
> CREATE TABLE user_activity (shard text, user text, ts timeu
try this:
CREATE COLUMNFAMILY post (
KEY uuid,
author uuid,
blog timeuuid, -- sortable
name text,
data text,
PRIMARY KEY ( KEY, blog )
);
create index on post (author);
SELECT * FROM post
WHERE
blog >= 4d6b5fc5-487b-11e3-a6f4-406c8f1838fa
AND blog <= 50573ef8-487b
On 11/07/2013 06:48 AM, Desimpel, Ignace wrote:
Total data size is only 3.5GB. Column family was created with SSTableSize : 10
MB
You may want to try a significantly larger size.
https://issues.apache.org/jira/browse/CASSANDRA-5727
NEWS.txt has some details and suggested procedures
- The hints schema was changed from 1.1 to 1.2. Cassandra automatically
snapshots and then truncates the hints column family as part of
starting up 1.2 for the first time. Additionally, upgraded nodes
will not store new hin
On Thu, Nov 7, 2013 at 7:01 PM, Krishna Chaitanya wrote:
> Check if its an issue with permissions or broken links..
>
>
I don't think permissions are an issue. You might be on to something
regarding the links.
I've been seeing this on 4 nodes, configured identically.
Here's what I think the prob
If I execute the above query from CQL shell, it doesn't work for me at
all... This is what I get -
cqlsh:pp> insert into test_new (employee_id, employee_name, value,
last_modified_date) values ('1', 'e29', 'some_new_value', now()) if not
exists
;
Bad Request: line 1:123 missing EOF at 'if'
Is th
Hi,
I'm looking for a way to view statistics. Mainly, I'd like to see the
distribution of writes and reads over the course of a day or a set of days. Is
there a way to do this through nodetool or by downloading a utility?
Thanks,
Parag
Conditional inserts/updates (lightweight transactions) are available only
in C* 2.0+.
Also most of the time you should try to think about alternative ways to
solve the problem and rely on these only if you cannot find a different
solution (the reason for this is that they come with performance pen
Hello,
I am looking out for some additional details about how to create a custom
Secondary Index.
I see CQL documentation where we can provide our implementation of
secondary index using the syntax:
CREATE CUSTOM INDEX ON users (email) USING 'path.to.the.IndexClass';
But there are no information
On Fri, Nov 8, 2013 at 10:31 AM, Elias Ross wrote:
> On Thu, Nov 7, 2013 at 7:01 PM, Krishna Chaitanya
> wrote:
>
>> Check if its an issue with permissions or broken links..
>>
>>
> I don't think permissions are an issue. You might be on to something
> regarding the links.
>
>
As it turns out (
http://www.datastax.com/dev/blog/metrics-in-cassandra12
On Fri, Nov 8, 2013 at 11:42 AM, Parag Patel wrote:
>Hi,
>
>
>
> I’m looking for a way to view statistics. Mainly, I’d like to see the
> distribution of writes and reads over the course of a day or a set of days.
> Is there a way to do
I need to be able to show the most recent changes that have occurred in a system, I understand inserting every update into a tracking table and deleting old updates may not be great, as I may end up creating millions of tombstones. i.e. don't do this:create table recent_updates(uuid timeuuid primar
Here are a couple ideas:
1. You can rotate tables and truncate to avoid deleting.
2. You can shard your tables (partition key) to mitigate hotspots.
3. You can use a column key to store rows in timeuuid sequence.
create table recent_updates_00 (shard text, uuid timeuuid, message text,
primary key
On 11/01/2013 03:03 PM, Robert Coli wrote:
On Fri, Nov 1, 2013 at 9:36 AM, Narendra Sharma
wrote:
I was successfully able to bootstrap the node. The issue was RF > 2.
Thanks again Robert.
For the record, I'm not entirely clear why bootstrapping two nodes into the
same range should have cause
20 matches
Mail list logo
