You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Lata Kannan <la...@oracle.com> on 2017/03/05 10:57:48 UTC
Limit on number of keyspaces/tables
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: Limit on number of keyspaces/tables
Posted by benjamin roth <br...@gmail.com>.
No seriously.
Am 05.03.2017 2:54 nachm. schrieb "Rakesh Kumar" <rakeshkumar464@outlook.com
>:
> > 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.kannan@oracle.com<mailto:
> lata.kannan@oracle.com>>:
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>
Re: Limit on number of keyspaces/tables
Posted by Rakesh Kumar <ra...@outlook.com>.
> 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" <la...@oracle.com>>:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Re: Limit on number of keyspaces/tables
Posted by benjamin roth <br...@gmail.com>.
I ask back: what's your intention
Am 05.03.2017 11:58 schrieb "Lata Kannan" <la...@oracle.com>:
> 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: Limit on number of keyspaces/tables
Posted by Lata Kannan <la...@oracle.com>.
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 done in this space and hence this query.
Thanks
--lata
On 3/6/2017 1:51 AM, Vladimir Yudovin wrote:
> 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 <https://winguzone.com?from=list> - Cloud Cassandra Hosting/
>
>
> ---- On Sun, 05 Mar 2017 14:40:42 -0500 *benjamin roth
> <br...@gmail.com>* wrote ----
>
> Why do you think 1 table consumes 1m??
>
> Am 05.03.2017 20:36 schrieb "Vladimir Yudovin"
> <vladyu@winguzone.com <ma...@winguzone.com>>:
>
>
> 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 <https://winguzone.com?from=list> - Cloud Cassandra
> Hosting/
>
>
> ---- On Sun, 05 Mar 2017 05:57:48 -0500 *Lata Kannan
> <lata.kannan@oracle.com <ma...@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
> a max on the number of tables that can be created in a
> cluster?
>
>
> --
> Thanks
> --lata
>
>
>
Re: Limit on number of keyspaces/tables
Posted by Vladimir Yudovin <vl...@winguzone.com>.
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 <brstgt@gmail.com> wrote ----
Why do you think 1 table consumes 1m??
Am 05.03.2017 20:36 schrieb "Vladimir Yudovin" <vladyu@winguzone.com>:
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 <lata.kannan@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
a max on the number of tables that can be created in a cluster?
--
Thanks
--lata
Re: Limit on number of keyspaces/tables
Posted by benjamin roth <br...@gmail.com>.
Why do you think 1 table consumes 1m??
Am 05.03.2017 20:36 schrieb "Vladimir Yudovin" <vl...@winguzone.com>:
> 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 <https://winguzone.com?from=list> - Cloud Cassandra Hosting*
>
>
> ---- On Sun, 05 Mar 2017 05:57:48 -0500 *Lata Kannan
> <lata.kannan@oracle.com <la...@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
> a max on the number of tables that can be created in a cluster?
>
>
> --
> Thanks
> --lata
>
>
>
Re: Limit on number of keyspaces/tables
Posted by Vladimir Yudovin <vl...@winguzone.com>.
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 <lata.kannan@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
a max on the number of tables that can be created in a cluster?
--
Thanks
--lata