Re: Inter-node messaging latency

2018-11-26 Thread sankalp kohli
Inter-node messaging is rewritten using Netty in 4.0. It will be better to test it using that as potential changes will mostly land on top of that. On Mon, Nov 26, 2018 at 7:39 AM Yuji Ito wrote: > Hi, > > I'm investigating LWT performance with C* 3.11.3. > It looks that the performance is bound

Re: View slow queries in V3

2018-11-26 Thread Alain RODRIGUEZ
Hello, I just saw this message still has no response. Do we have any inbuilt features to log slow\resource heavy queries? I think we don't have this in Cassandra yet. I also believe it's in DSE, if it's something you'd really need :). I tried to check data in system_traces.sessions to check c

Re: Problem with hints

2018-11-26 Thread Alain RODRIGUEZ
Hello, It's hard to say what the best configuration is. *max_hints_delivery_threads*: I think it's said you should use 2 delivery thread per DC (as a starting point). *max_hint_window_in_ms:* depends on your need (and what the cluster can bear of course). Generally, the default of 3 hours is use

Re: Exception when running sstableloader

2018-11-26 Thread Alain RODRIGUEZ
Hello LAD, I do not know much about the SSTable Loader. I carefully stayed away from it so far :). But it seems it's using thrift to talk to Cassandra. Some of your rows might be too big and increasing 'thrift_framed_transport_size_in_mb' should have helped indeed. Did you / Would you try with i

Re: system_auth keyspace replication factor

2018-11-26 Thread Oleksandr Shulgin
On Fri, Nov 23, 2018 at 5:38 PM Vitali Dyachuk wrote: > > We have recently met a problem when we added 60 nodes in 1 region to the > cluster > and set an RF=60 for the system_auth ks, following this documentation > https://docs.datastax.com/en/cql/3.3/cql/cql_using/useUpdateKeyspaceRF.html > Sad

Re: Cassandra 2.1 bootstrap - No streaming progress from one node

2018-11-26 Thread Alain RODRIGUEZ
Hello, +1 with Sean above. In Cassandra 2.2 you got the new 'nodetool resume' command to resume a bootstrap. For C*2.1, nothing equivalent sadly. Thus old school technics apply and the possible alternatives are Option 1 - safe and slow- Stop Cassandra from the stuck joining node. Remove everythin

Re: system_auth keyspace replication factor

2018-11-26 Thread Sam Tunnicliffe
> I suspect some of the intermediate queries (determining role, etc) happen at > quorum in 2.2+, but I don’t have time to go read the code and prove it. This isn’t true. Aside from when using the default superuser, only CRM::getAllRoles reads at QUORUM (because the resultset would include the