I have simple table like below
CREATE TABLE mytable ( id text, type text, value text, active boolean, PRIMARY KEY (id) );
The column value can have data ranging from 100kb to 2MB.
I am writing data and reading data into this table frequently. I am experiencing these issues
- Long running queries even for simple queries like select active from mytable where id ='1234';
- I have also seen frequent GC flushes every 10 to 15 mins with GC pause as ranging from 700 ms to 1 sec
- Cassandra connection exceptions
I am using spring data cassandra.
I do not have any tombstones in this table, But the other tables have tombstones.
any suggestions to fix this would be of great help.