incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Coli <rc...@eventbrite.com>
Subject Re: Reasonable range for the max number of tables?
Date Mon, 04 Aug 2014 19:47:53 GMT
On Mon, Aug 4, 2014 at 12:42 PM, Kevin Burton <burton@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 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.


> But what's the max number of tables?  If I'm doing hourly tables and have
> 30 days of them this would be 720 individual tables.
>

Probably pushing it.

=Rob

Mime
View raw message