question

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

1. Long running queries even for simple queries like select active from mytable where id ='1234';
2. I have also seen frequent GC flushes every 10 to 15 mins with GC pause as ranging from 700 ms to 1 sec
3. 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.