Re: Limit on number of keyspaces/tables

2017-03-05 Thread Lata Kannan
05:57:48 -0500 *Lata Kannan mailto:lata.kan...@oracle.com>>* wrote Hi I just wanted to check if there is any known limit to the number of keyspaces one can create in a Cassandra cluster? Alternatively is there

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 05:57:48 -0500 Lata Kannan <lata.kan...@oracle.com> wrote Hi I just wanted to check if there is any known limit to the number of keyspaces one can create in a Cassandra cluster? Altern

Re: Limit on number of keyspaces/tables

2017-03-05 Thread benjamin roth
//winguzone.com?from=list> - Cloud Cassandra Hosting* > > > On Sun, 05 Mar 2017 05:57:48 -0500 *Lata Kannan > >* wrote > > Hi > > I just wanted to check if there is any known limit to the number of > keyspaces one can create in a Cassandra cluster? Alterna

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
I just wanted to check if there is any known limit to the number of keyspaces one can create in a Cassandra cluster? Alternatively is there a max on the number of tables that can be created in a cluster? -- Thanks --lata

Re: Limit on number of keyspaces/tables

2017-03-05 Thread benjamin roth
No seriously. Am 05.03.2017 2:54 nachm. schrieb "Rakesh Kumar" : > > I ask back: what's your intention > > May be documenting the limitations of Cassandra to show Oracle is better > :-) > > Am 05.03.2017 11:58 schrieb "Lata Kannan" lata.kan...@oracle.com>>: >

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Rakesh Kumar
> I ask back: what's your intention May be documenting the limitations of Cassandra to show Oracle is better :-) Am 05.03.2017 11:58 schrieb "Lata Kannan" mailto:lata.kan...@oracle.com>>: ^

Re: Limit on number of keyspaces/tables

2017-03-05 Thread benjamin roth
I ask back: what's your intention Am 05.03.2017 11:58 schrieb "Lata Kannan" : > Hi > > I just wanted to check if there is any known limit to the number of > keyspaces one can create in a Cassandra cluster? Alternatively is there a > max on the number of tables th

Limit on number of keyspaces/tables

2017-03-05 Thread Lata Kannan
Hi I just wanted to check if there is any known limit to the number of keyspaces one can create in a Cassandra cluster? Alternatively is there a max on the number of tables that can be created in a cluster? -- Thanks --lata

Re: Practical limit to number of keyspaces?

2014-07-18 Thread Sourabh Agrawal
t; *From:* Sourabh Agrawal > *Sent:* Thursday, July 10, 2014 11:22 PM > *To:* user@cassandra.apache.org > *Subject:* Practical limit to number of keyspaces? > > Hi, > > We are using 2.0.x in production env. Each node has 8G heap. Is there a > practical limit to how ma

Re: Practical limit to number of keyspaces?

2014-07-11 Thread Jack Krupansky
bject: Practical limit to number of keyspaces? 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 Ag

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: Effect of number of keyspaces on write-throughput....

2014-05-19 Thread Krishna Chaitanya
Thankyou for making these issues clear. Currently, in my datamodel, I have the current second( seconds-from-epoch) as the row key and micro second with the client number as the column key. Hence, all the packets received during a particular second on all the clients are stored in t

Re: Effect of number of keyspaces on write-throughput....

2014-05-19 Thread Aaron Morton
> Each client is writing to a separate keyspace simultaneously. Hence, is there > a lot of switching of keyspaces? > > I would think not. If the client app is using one keyspace per connection there should be no reason for the driver to change keyspaces. > But, I observed that when using a

Re: Effect of number of keyspaces on write-throughput....

2014-05-15 Thread Krishna Chaitanya
Hello, Thanks for the reply. Currently, each client is writing about 470 packets per second where each packet is 1500 bytes. I have four clients writing simultaneously to the cluster. Each client is writing to a separate keyspace simultaneously. Hence, is there a lot of switching of keyspaces?

Re: Effect of number of keyspaces on write-throughput....

2014-05-12 Thread Aaron Morton
> On the homepage of libQtCassandra, its mentioned that switching between > keyspaces is costly when storing into Cassandra thereby affecting the write > throughput. Is this necessarily true for other libraries like pycassa and > hector as well? > > When using the thrift connection the keyspac

Effect of number of keyspaces on write-throughput....

2014-05-10 Thread Krishna Chaitanya
Hello, I have an application that writes network packets to a Cassandra cluster from a number of client nodes. It uses the libQtCassandra library to access Cassandra. On the homepage of libQtCassandra, its mentioned that switching between keyspaces is costly when storing into Cassandra thereby affe

Re: nodetool repair seems to increase linearly with number of keyspaces

2013-11-26 Thread Christopher J. Bottaro
t;>> keyspaces (one for each company). >>> >>> One thing we are noticing is that nodetool repair across all of the >>> keyspaces seems to increase linearly based on the number of keyspaces. For >>> example, if we have a 6 node ec2 (m1.large) cluste

Re: nodetool repair seems to increase linearly with number of keyspaces

2013-11-25 Thread Robert Coli
On Mon, Nov 25, 2013 at 12:28 PM, John Pyeatt wrote: > Are you using Vnodes? We are and they are set to 256 > What version of cassandra are you running. We are running 1.2.9 > Vnode performance vis a vis repair is this JIRA issue : https://issues.apache.org/jira/browse/CASSANDRA-5220 Unfortunat

Re: nodetool repair seems to increase linearly with number of keyspaces

2013-11-25 Thread John Pyeatt
gt; One thing we are noticing is that nodetool repair across all of the >> keyspaces seems to increase linearly based on the number of keyspaces. For >> example, if we have a 6 node ec2 (m1.large) cluster across 3 Availability >> Zones and create 20 keyspaces a nodetool repair -pr on one

Re: nodetool repair seems to increase linearly with number of keyspaces

2013-11-25 Thread Christopher J. Bottaro
rease linearly based on the number of keyspaces. For > example, if we have a 6 node ec2 (m1.large) cluster across 3 Availability > Zones and create 20 keyspaces a nodetool repair -pr on one node takes 3 > hours even with no data in any of the keyspaces. If I bump that up to 40 > keyspac

nodetool repair seems to increase linearly with number of keyspaces

2013-11-20 Thread John Pyeatt
We have an application that has been designed to use potentially 100s of keyspaces (one for each company). One thing we are noticing is that nodetool repair across all of the keyspaces seems to increase linearly based on the number of keyspaces. For example, if we have a 6 node ec2 (m1.large

Re: Number of keyspaces

2012-05-23 Thread Rob Coli
On Tue, May 22, 2012 at 4:56 AM, samal wrote: > Not ideally, now cass has global memtable tuning. Each cf correspond to > memory  in ram. Year wise cf means it will be in read only state for next > year, memtable  will still consume ram. An empty memtable seems unlikely to consume a meaningful am

Re: Number of keyspaces

2012-05-23 Thread Franc Carter
27;t update previous years. >>> >>> cheers >>> >>> >>>> >>>> Cheers >>>> >>>> - >>>> Aaron Morton >>>> Freelance Developer >>>> @aaronmorton

Re: Number of keyspaces

2012-05-23 Thread aaron morton
gt;> >>> - >>> Aaron Morton >>> Freelance Developer >>> @aaronmorton >>> http://www.thelastpickle.com >>> >>> On 22/05/2012, at 6:58 PM, R. Verlangen wrote: >>> >>>> Yes, it does. However the

Re: Number of keyspaces

2012-05-22 Thread Franc Carter
>> On 22/05/2012, at 6:58 PM, R. Verlangen wrote: >>> >>> Yes, it does. However there's no real answer what's the limit: it >>> depends on your hardware and cluster configuration. >>> >>> You might even want to search the archives of this

Re: Number of keyspaces

2012-05-22 Thread aaron morton
nmorton >> http://www.thelastpickle.com >> >> On 22/05/2012, at 6:58 PM, R. Verlangen wrote: >> >>> Yes, it does. However there's no real answer what's the limit: it depends >>> on your hardware and cluster configuration. &

Re: Number of keyspaces

2012-05-22 Thread Luís Ferreira
nds on >> your hardware and cluster configuration. >> >> You might even want to search the archives of this mailinglist, I remember >> this has been asked before. >> >> Cheers! >> >> 2012/5/21 Luís Ferreira >> Hi, >> >>

Re: Number of keyspaces

2012-05-22 Thread samal
t;> On 22/05/2012, at 6:58 PM, R. Verlangen wrote: >> >> Yes, it does. However there's no real answer what's the limit: it depends >> on your hardware and cluster configuration. >> >> You might even want to search the archives of this mailinglist, I

Re: Number of keyspaces

2012-05-22 Thread Franc Carter
en wrote: > > Yes, it does. However there's no real answer what's the limit: it depends > on your hardware and cluster configuration. > > You might even want to search the archives of this mailinglist, I remember > this has been asked before. > > Cheers! > &

Re: Number of keyspaces

2012-05-22 Thread R. Verlangen
, I remember > this has been asked before. > > Cheers! > > 2012/5/21 Luís Ferreira > >> Hi, >> >> Does the number of keyspaces affect the overall cassandra performance? >> >> >> Cumprimentos, >> Luís Ferreira >> >> >> >> > > > -- > With kind regards, > > Robin Verlangen > www.robinverlangen.nl > > > -- With kind regards, Robin Verlangen www.robinverlangen.nl

Re: Number of keyspaces

2012-05-22 Thread aaron morton
on > your hardware and cluster configuration. > > You might even want to search the archives of this mailinglist, I remember > this has been asked before. > > Cheers! > > 2012/5/21 Luís Ferreira > Hi, > > Does the number of keyspaces affect the overall cass

Re: Number of keyspaces

2012-05-21 Thread R. Verlangen
Yes, it does. However there's no real answer what's the limit: it depends on your hardware and cluster configuration. You might even want to search the archives of this mailinglist, I remember this has been asked before. Cheers! 2012/5/21 Luís Ferreira > Hi, > > Does the

Number of keyspaces

2012-05-21 Thread Luís Ferreira
Hi, Does the number of keyspaces affect the overall cassandra performance? Cumprimentos, Luís Ferreira