Re: Reasonable range for the max number of tables?

2014-08-18 Thread Cheng Ren
-range-for-the-max-number-of-tables-tp7596094p7596119.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: Reasonable range for the max number of tables?

2014-08-05 Thread Phil Luckhurst
is it the accepted practice to have multiple Cassandra installations? -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Reasonable-range-for-the-max-number-of-tables-tp7596094p7596106.html Sent from the cassandra-u...@incubator.apache.org mailing

Re: Reasonable range for the max number of tables?

2014-08-05 Thread Mark Reddy
. If you want to be able to segregate customer data in Cassandra is it the accepted practice to have multiple Cassandra installations? -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Reasonable-range-for-the-max-number-of-tables

Re: Reasonable range for the max number of tables?

2014-08-05 Thread Phil Luckhurst
but perhaps that's the price we have to pay to scale. And I still think this needs to be made more prominent in the documentation. Thanks Phil -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Reasonable-range-for-the-max-number-of-tables

Re: Reasonable range for the max number of tables?

2014-08-05 Thread Jack Krupansky
in this area. -- Jack Krupansky -Original Message- From: Phil Luckhurst Sent: Tuesday, August 5, 2014 4:09 AM To: cassandra-u...@incubator.apache.org Subject: Re: Reasonable range for the max number of tables? Is there any mention of this limitation anywhere in the Cassandra documentation

Re: Reasonable range for the max number of tables?

2014-08-05 Thread Michal Michalski
customers but perhaps that's the price we have to pay to scale. And I still think this needs to be made more prominent in the documentation. Thanks Phil -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Reasonable-range-for-the-max-number

Reasonable range for the max number of tables?

2014-08-04 Thread Kevin Burton
What's a reasonable range for the max number of tables? We have an append-only table system and I've been thinking of moving them to using hourly / partitioned tables. This means I can do things like easily drop older tables if I run out of disk space. It also means that I can fadvise the most

Re: Reasonable range for the max number of tables?

2014-08-04 Thread Robert Coli
On Mon, Aug 4, 2014 at 12:42 PM, Kevin Burton bur...@spinn3r.com wrote: What's a reasonable range for the max number of tables? We have an append-only table system and I've been thinking of moving them to using hourly / partitioned tables. Low Numbers of Hundreds This means I can do

Re: Reasonable range for the max number of tables?

2014-08-04 Thread Kevin Burton
This means I can do things like easily drop older tables if I run out of disk space. It also means that I can fadvise the most recent tables and force them into table cache. If you have to use fadvise to do this, you are almost certainly Doing It Wrong. possibly.. fincore is also useful.

Re: Reasonable range for the max number of tables?

2014-08-04 Thread Robert Coli
On Mon, Aug 4, 2014 at 1:35 PM, Kevin Burton bur...@spinn3r.com wrote: What are the bottlenecks here ? Is this an HDD issue because we're running them on SSD. I agree that that would be significant on HDD ... Heap consumption. There are probably some JIRA tickets touching on the memory

Re: Reasonable range for the max number of tables?

2014-08-04 Thread Jack Krupansky
apart, with no warning. -- Jack Krupansky From: Robert Coli Sent: Monday, August 4, 2014 4:54 PM To: user@cassandra.apache.org Subject: Re: Reasonable range for the max number of tables? On Mon, Aug 4, 2014 at 1:35 PM, Kevin Burton bur...@spinn3r.com wrote: What are the bottlenecks here