Re: janus cassandra limitations


Kelvin Lawrence <kelvin....@...>
 


Hi Mirosław,

Janus graph uses an adjacency list model for storing vertices and edges. A vertex, its properties and all of its adjacent edges are stored in a single Cassandra row,

The Janus Graph documentation goes into these issues in some detail.
http://docs.janusgraph.org/latest/index.html

You are using a very old version of Titan BTW. It would be worth upgrading if you can.

Cheers,
Kelvin

On Wednesday, August 2, 2017 at 10:36:39 AM UTC-5, Mirosław Głusiuk wrote:

Hi all,


from what I know janus is fork of titan which means if it does not have different storage impl it could have problems with bigger data count.


"janusgraph/titan can store up to a quintillion edges (2^60) and half as many vertices. "

"The maximum number of cells (rows x columns) in a single partition is 2 billion."


2 billions is about (2^31)

in cassandra schema we always have 2 columns per table so you could store about (2^30) values per key

so if not mistaken "half as many vertices" is not for cassandra storage backend?


I'm using titan 0.4.4 and after having like 50M+ vertices I have spot cassandra started to complain about "Compacting large partition titan/vertexindex:00".
As I understand partition for key 0x00 already is too big and start to causing performance during compaction.
Also I spot that it contains one value per each created vertex (8+8=16bytes). so it is already bigger than 500MB in size which is already bigger than cassandra recommendation.
http://docs.datastax.com/en/landing_page/doc/landing_page/planning/planningPartitionSize.html


So my question is what is real janusgraph/titan limit for cassandra backend which will not "kill" cassandra?

Btw I also spot that some keys from "edgestore" table for "supernodes" are also bigger than 1GB with my current graph.


Could anyone explain how janusgraph stores data in cassandra and how to configure it to prevent storing huge rows?

Join {janusgraph-users@lists.lfaidata.foundation to automatically receive all group messages.