We are seeing some queries are appearing in debug.log and our memory and CPU got saturated during the load test.
<SELECT * FROM cam.cam_counter WHERE target = U-Son0048004168 LIMIT 5000>, time 1610 msec - slow timeout 500 msec/cross-node <SELECT * FROM cam.cam_counter WHERE target = U-Son0048004730 LIMIT 5000>, time 1010 msec - slow timeout 500 msec
Table definition:-
CREATE TABLE IF NOT EXISTS cam_counter (
target text,
counter text,
zoneid text,
value int,
last_updated_timestamp bigint,
expiry_timestamp bigint,
PRIMARY KEY(target, counter, zoneid)
) WITH gc_grace_seconds=3600;
We are using Cassandra 3.11.5 open source.
We have 11 nodes C* cluster with single data center. We are using SSD storage.
Can you please suggest what might be the problem?
