The main overhead is that each table locks 1MB of Java heap, so if you have 
1000 tables it will use 1GB of RAM just for managing the tables, even if they 
are empty.

--
Jacques-Henri Berthemet

From: Alaa Zubaidi (PDF) [mailto:alaa.zuba...@pdf.com]
Sent: Friday, February 16, 2018 1:05 AM
To: user@cassandra.apache.org; Dinesh Joshi <dinesh.jo...@yahoo.com>
Subject: Re: overhead of empty tables

Thanks Dinesh,
We have 36332 files under the data folder

On Thu, Feb 15, 2018 at 3:45 PM, Dinesh Joshi 
<dinesh.jo...@yahoo.com.invalid<mailto:dinesh.jo...@yahoo.com.invalid>> wrote:
Each table in a keyspace is stored as a separate directory in the data 
directory. If you many tables you'll have a lot of files. Some file systems 
have issues dealing with a lot of files in a single directory. Other than that, 
there will likely be some book keeping overhead within the Cassandra process. 
How many tables are we talking about here?

Here's more information about it: 
https://docs.datastax.com/en/cassandra/3.0/cassandra/dml/dmlHowDataWritten.html<https://docs.datastax.com/en/cassandra/3.0/cassandra/dml/dmlHowDataWritten.html>

Dinesh


On Thursday, February 15, 2018, 3:34:49 PM PST, Alaa Zubaidi (PDF) 
<alaa.zuba...@pdf.com<mailto:alaa.zuba...@pdf.com>> wrote:


Is there any overhead if my keyspace contains many empty tables?
Thanks
Alaa

This message may contain confidential and privileged information. If it has 
been sent to you in error, please reply to advise the sender of the error and 
then immediately permanently delete it and all attachments to it from your 
systems. If you are not the intended recipient, do not read, copy, disclose or 
otherwise use this message or any attachments to it. The sender disclaims any 
liability for such unauthorized use. PLEASE NOTE that all incoming e-mails sent 
to PDF e-mail accounts will be archived and may be scanned by us and/or by 
external service providers to detect and prevent threats to our systems, 
investigate illegal or inappropriate behavior, and/or eliminate unsolicited 
promotional e-mails (“spam”). If you have any concerns about this process, 
please contact us at legal.departm...@pdf.com<mailto:legal.departm...@pdf.com>.



--

Alaa Zubaidi
PDF Solutions, Inc.
333 West San Carlos Street, Suite 1000
San Jose, CA 95110  USA
Tel: 408-283-5639
fax: 408-938-6479
email: alaa.zuba...@pdf.com<mailto:alaa.zuba...@pdf.com>

This message may contain confidential and privileged information. If it has 
been sent to you in error, please reply to advise the sender of the error and 
then immediately permanently delete it and all attachments to it from your 
systems. If you are not the intended recipient, do not read, copy, disclose or 
otherwise use this message or any attachments to it. The sender disclaims any 
liability for such unauthorized use. PLEASE NOTE that all incoming e-mails sent 
to PDF e-mail accounts will be archived and may be scanned by us and/or by 
external service providers to detect and prevent threats to our systems, 
investigate illegal or inappropriate behavior, and/or eliminate unsolicited 
promotional e-mails (“spam”). If you have any concerns about this process, 
please contact us at legal.departm...@pdf.com<mailto:legal.departm...@pdf.com>.

Reply via email to