Re: Practical limit to number of keyspaces?

2014-07-18 Thread Sourabh Agrawal
> in a relational database), it's relatively straightforward to allow > disabling the SlabAllocator.” Emphasis on “almost certainly a Bad Idea.” > > See: > https://issues.apache.org/jira/browse/CASSANDRA-5935 > “Allow disabling slab allocation” > > -- Jack Krupansky > &g

Practical limit to number of keyspaces?

2014-07-10 Thread Sourabh Agrawal
Hi, We are using 2.0.x in production env. Each node has 8G heap. Is there a practical limit to how many keyspaces I can have? Please note that many keyspaces remain mostly dormant while others have very high level of activity. -- Sourabh Agrawal Bangalore +91 9945657973

Re: keyspace with hundreds of columnfamilies

2014-07-10 Thread Sourabh Agrawal
ate : 03/07/2014 21:55 >>> > Objet : Re: keyspace with hundreds of columnfamilies >>> > >>> > thank you for the replies; I am rethinking the schema design, one >>> > possible solution is to "implode" one dimension and get N times less >>> CFs. >>> >>> > With this approach I would come up with (cql) tables with up to 100 >>> > columns; would that be a problem? >>> > >>> > Thank You, >>> > Tommaso >>> > >>> >> >> > -- Sourabh Agrawal Bangalore +91 9945657973

Ideal values for coreConnectionsForRemote and maxConnectionsForRemote : CQL Java Driver

2014-05-06 Thread Sourabh Agrawal
What are the ideal values for coreConnectionsForRemote and maxConnectionsForRemote in CQL Java Driver ( by Datastax). -- Sourabh Agrawal Bangalore +91 9945657973

Re: Read performance in map data type

2014-04-01 Thread Sourabh Agrawal
; On Mon, Mar 31, 2014 at 9:13 PM, Apoorva Gaurav < >> apoorva.gau...@myntra.com> wrote: >> >>> Thanks Robert, Is there a workaround, as in our test setups we keep >>> dropping and recreating tables. >>> >> >> Use unique keyspace (or tabl

Re: Read performance in map data type

2014-03-29 Thread Sourabh Agrawal
for this specific issue but tried it once > earlier and found the performance slower than 1.x; isn't so? > > > On Sat, Mar 29, 2014 at 3:30 PM, Sourabh Agrawal > wrote: > >> Hi Apoorva, >> >> Do you always query on studentID only or do you need to que

Re: Read performance in map data type

2014-03-29 Thread Sourabh Agrawal
ect * from marks_table where >>> studentID = ? >>> >>> 3. model as (studentID int, subjectID int, marks int, PRIMARY >>> KEY(studentID, subjectID) and query as select * from marks_table where >>> studentID = ? and subjectID in (?, ?, ??) number of subjectIDs in >>> query being ~1K. >>> >>> What can be the bottlenecks. Is it better if we model as (studentID int, >>> subjct_marks_json text) and query by studentID. >>> >>> -- >>> Thanks & Regards, >>> Apoorva >>> >> >> > > > -- > Thanks & Regards, > Apoorva > -- Sourabh Agrawal Bangalore +91 9945657973

Re: High CPU load on one node in the cluster

2014-02-19 Thread Sourabh Agrawal
gt; On Wed, Feb 19, 2014 at 8:47 AM, Sourabh Agrawal > wrote: > >> Below is CPU usage from top. I don't see any steal. Idle time is pretty >> low. >> >> Cpu(s): 83.3%us, 14.5%sy, 0.0%ni, 0.5%id, 0.0%wa, 0.0%hi, 1.7%si, >> 0.0%st >> >> An

Re: High CPU load on one node in the cluster

2014-02-19 Thread Sourabh Agrawal
you may want to > consider paying for dedicated instances. > > > On Wed, Feb 19, 2014 at 2:30 AM, Sourabh Agrawal > wrote: > >> Hi, >> >> I am running cassandra 2.0.3 cluster on 4 AWS nodes. memory arguments are >> the following for each node : >> -Xms8G -

High CPU load on one node in the cluster

2014-02-19 Thread Sourabh Agrawal
like CMS GC is running every 1-2 seconds. Any pointers on how to debug this? -- Sourabh Agrawal Bangalore +91 9945657973