I have an app polling a few CFs (select first N * from CF), there were data in CFs but later were deleted so CFs were empty for a long time. I found Cassandra CPU usage was getting high to 80%, normally it uses less than 30%. I issued the select query manually and feel the response is slow. I have tried nodetool compact/repair for those CFs but that does not work. later, I issue 'truncate' for all the CFs and CPU usage gets down to 1%.

Can somebody explain to me why I need to truncate an empty CF? and what else I could do to bring the CPU usage down?

I am running 0.8.6.

Thanks,

Daning

Reply via email to