Hi Everyone, Facing one issue with CPU Utilization with BE StarRocks. When we try to delete records using stream_load from multiple processes, around 10+ processes doing the same activity parallelly, the CPU utilization reaches 99.9%. How do we handle this issue? Or how do we verify what process it is running at that moment? I haven't seen this issue with earlier eventhough we process multiple parallel processing on same table. Once, we started deleting records with stream load and re-insert, I observed this behaviour.

If you want to see the running process you can run

show running queries;

For the cpu usage, set

query_queue_cpu_used_permille_limit

system variable to a number below 1000

Thanks for the reply, will test this variable.