Re: Limit on number of keyspaces/tables

2017-03-05 Thread Lata Kannan
Thanks much. I was reading up some docs on this out of academic interest and came across a few posts on this at http://grokbase.com/t/cassandra/user/14bs6tjxh5/keyspace-and-table-cf-limits, but these discussions were about a couple of years back. I was not sure if something recent has been don

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
>From source code and measurement. Try to create a lot of tables with small write to each of them and monitor Java heap. Each table takes some more then 1M. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 14:40:42 -0500 benjamin roth

Re: Limit on number of keyspaces/tables

2017-03-05 Thread benjamin roth
Why do you think 1 table consumes 1m?? Am 05.03.2017 20:36 schrieb "Vladimir Yudovin" : > Hi, > > there is no such hard limit, but each table consume at least 1M memory, so > 1000 tables takes at least 1G. > > Best regards, Vladimir Yudovin, > *Winguzone - Cloud

Re: Limit on number of keyspaces/tables

2017-03-05 Thread Vladimir Yudovin
Hi, there is no such hard limit, but each table consume at least 1M memory, so 1000 tables takes at least 1G. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 05:57:48 -0500 Lata Kannan wrote Hi I jus

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 that can be created in a cluster? >