Re: Tombstones? 4.0.1

This is not the right data model for Cassandra. Strong encouragement to watch one of Patrick McFadin's data modeling videos on youtube. You very much want to always query where a WHERE clause, which usually means knowing a partition key (or set of partition keys) likely to contain your data, and u

Re: Tombstones? 4.0.1

Hi Jeff - yes, I'm doing a select without where - specifically: select uuid from table limit 1000; Not inserting nulls, and nothing is TTL'd. At this point with zero rows, the above select fails. Sounds like my application needs a redesign as doing 1 billion inserts, and 100 million deletes res

Re: Tombstones? 4.0.1

The tombstone threshold is "how many tombstones are encountered within a single read command", and the default is something like 100,000 ( https://github.com/apache/cassandra/blob/trunk/conf/cassandra.yaml#L1293-L1294 ) Deletes are not forbidden, but you have to read in such a way that you touch l

Re: Tombstones? 4.0.1

If the table has zero rows you could truncate it On Mon, Oct 25, 2021 at 6:29 PM Joe Obernberger < joseph.obernber...@gmail.com> wrote: > Update - after 10 days, I'm able to use the table again; prior to that all > selects timed out. > Are deletes basically forbidden with Cassandra? If you have

Re: Tombstones? 4.0.1

Update - after 10 days, I'm able to use the table again; prior to that all selects timed out. Are deletes basically forbidden with Cassandra?  If you have a table where you want to do lots of inserts and deletes, is there an option that works in Cassandra?  Even thought the table now has zero ro

Re: How to find traffic profile per client on a Cassandra server?

How is client makes call to Cassandra, is they load balancer, Can we look at load balancer log. This usually captures and respond for no of client calls per second. Ask them to share their monitoring chart If your question is why Cassandra load went up, there could be multiple reasons, balanc

Re: How to find traffic profile per client on a Cassandra server?

For older version (Cassandra < 4.0) you can use `nodetool settraceprobability` to get a sample of queries (or all queries, if your cluster can handle the extra load). For newer version (>= 4.0) you can use the above, or the new Full Query Logging