Re: Questions about C* performance related to tombstone

2019-04-10 Thread Li, George
r writing > collections. This is an accident typically. > > The 'active' flag is good if you want to be able to go back and look > at old deleted assignments. If you don't care about that, use a > normal delete. > > Jon > > On Tue, Apr 9, 2019 at 7:00 AM Li, George > wr

Questions about C* performance related to tombstone

2019-04-09 Thread Li, George
Hi, I have a table defined like this: CREATE TABLE myTable ( course_id text, assignment_id text, assignment_item_id text, data text, boolean active, PRIMARY KEY (course_id, assignment_id, assignment_item_id) ); i.e. course_id as the partition key and assignment_id, assignment_item_id as

Is it more performant to split data with the same schema into multiple keyspaces, as supposed to put all of them into the same keyspace?

2014-11-13 Thread Li, George
Hi, we use Cassandra to store some association type of data. For example, store user to course (course registrations) association and user to school (school enrollment) association data. The schema for these two types of associations are the same. So there are two options to store the data: 1. Put

Re: Cassandra Restore data from snapshots and Different Counts

2014-10-22 Thread Li, George
I assume that you are restoring snapshot data onto a new ring with the same topology (i.e. if the old ring has n nodes, your new ring has n nodes also). I discussed this a consultant from DataStax, and he told me that I need to make sure each new node in the new ring need to have the same token

Cassandra sometimes times out on write queries and it spends majority amount of the CPU time on method org.apache.cassandra.db.marshal.AbstractCompositeType.compare()

2014-09-23 Thread Li, George
Hi, I am running some load test in a 5 node Cassandra cluster (EC2, single region, each node has 15 GB RAM, Cassandra version 2.0.6, replication factor 3). My Java program uses Java driver version 2.0.6 and it does 2000 rounds of batch write queries, each with 8 inserts, 8 updates and 8 deletes.