Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-05 Thread Satoshi Hikida
Hi, I'm going to try to update the DataStax's Java Driver version from 2.1.8 to 3.1.3. First I ran the test program and measured the time with both drivers v2.1.8 and v3.1.3. The test program is simply Build a Cluster and connect to it and execute a simple select statement, and close the

Frozen type sin cassandra.

2017-03-05 Thread anuja jain
Hi, Is there is difference between creating column of type frozen and frozen where list_double is UDT of type frozen ? Also how to create a solr index on such columns?

Re: How to find total data size of a keyspace.

2017-03-05 Thread anuja jain
nodetool status or nodetool ring still gives the load of all keyspaces on cluster. On Tue, Feb 28, 2017 at 6:56 PM, Surbhi Gupta wrote: > Nodetool status key space_name . > On Tue, Feb 28, 2017 at 4:53 AM anuja jain wrote: > >> Hi, >> Using

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

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

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 lata.kan...@oracle.com wrote Hi I just

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"

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" >: ^

Re: Any way to control/limit off-heap memory?

2017-03-05 Thread Hannu Kröger
If bloom filters are taking too much memory, you can adjust bloom filters: https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_tuning_bloom_filters_c.html Hannu > On 4 Mar 2017, at

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

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