Re: Cassandra 3.11 is compacting forever

2017-09-03 Thread kurt greaves
Can't say that message explains why the compaction would be stuck. Generally not a good sign and you might need to investigate more but hopefully shouldn't be related. Has that stuck compaction moved since last week? On 1 September 2017 at 22:54, Fay Hou [Storage Service] ­ < fay...@coupang.com>

Re: timeouts on counter tables

2017-09-03 Thread Rudi Bruchez
Le 30/08/2017 à 05:33, Erick Ramirez a écrit : Is it possible at all that you may have a data hotspot if it's not hardware-related? It does not seem so, The partition key seems well distributed and the queries update different keys. We have dropped counter_mutation messages in the log :

Re: timeouts on counter tables

2017-09-03 Thread Rudi Bruchez
Le 28/08/2017 à 03:30, kurt greaves a écrit : If every node is a replica it sounds like you've got hardware issues. Have you compared iostat to the "normal" nodes? I assume there is nothing different in the logs on this one node? Also sanity check, you are using DCAwareRoundRobinPolicy? ​

Re: old big tombstone data file occupy much disk space

2017-09-03 Thread Shalom Sagges
Try this blog by The Last Pickle: http://thelastpickle.com/blog/2016/10/18/user-defined-compaction.html Shalom Sagges DBA We Create Meaningful Connections On Sat, Sep 2, 2017