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?