Hawkular metrics & Cassandra perfomance

Posted on

We have huge number of log entries, like this:
Query SELECT time, n_value, tags FROM data_temp_2018072306 WHERE tenant_id = ? AND type = ? AND metric = ? AND time >= ? AND time < ? ORDER BY time ASC LIMIT ? is not prepared on, preparing before retrying executing. Seeing this message a few times is fine, but seeing it a lot may be source of performance problems

Apparently, this issue is related to cassandra prepared statements and prep statements cache size which is 1/256th of the heap.

Openshift cluster: v3.9
Cassandra: 4 nodes
Hawkular: 4 pods

Is there any recommended way to solve this?