primary key ((partition_key, clustering_key)) Also, this primary key definition does not define a partitioning key and a clustering key. It defines a *composite* partition key.
If you want it to instantiate both a partition and clustering key, get rid of one set of parens. primary key (partition_key, clustering_key) On Tue, Jun 2, 2020 at 1:31 AM onmstester onmstester <onmstes...@zoho.com.invalid> wrote: > I just changed these properties to increase flushed file size (decrease > number of compactions): > > - memtable_allocation_type from heap_buffers to offheap_objects > - memtable_offheap_space_in_mb: from default (2048) to 8192 > > Using default value for other memtable/compaction/commitlog configurations > . > > After a few hours some of nodes stopped to do any mutations (dropped > mutaion increased) and also pending flushes increased, they were just up > and running and there was only a single CPU core with 100% usage(other > cores was 0%). other nodes on the cluster determines the node as DN. Could > not access 7199 and also could not create thread dump even with jstack -F. > > Restarting Cassandra service fixes the problem but after a while some > other node would be DN. > > Am i missing some configurations? What should i change in cassandra > default configuration to maximize write throughput in single node/cluster > in write-heavy scenario for the data model: > Data mode is a single table: > create table test( > text partition_key, > text clustering_key, > set<text> rows, > primary key ((partition_key, clustering_key)) > > > vCPU: 12 > Memory: 32GB > Node data size: 2TB > Apache cassandra 3.11.2 > JVM heap size: 16GB, CMS, 1GB newgen > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > >
