How to get which keyspaces or tables or queries have non-token aware request

Dear All,

In scylladb monitoring stack, we saw some “Non-Token Aware Queries” there. Since there are lots of services in the system (most are token aware), we would like to know if there is any log we could enable to get which keyspaces or tables or queries have non-token aware request?

Tim

As far as I know there is no such log currently. We only have a generic counter, which is increased every time a query lands on a coordinator which is not itself a replica too.

Is it possible to add this feature or log for identify service quickly?

Tim

It can be added yes, but we have to carefully consider how we present this information: just logging it could flood the logs.

Please open an issue with the feature request.

Open new issue here: add more info about non-token aware queries · Issue #12577 · scylladb/scylladb · GitHub

Since there is also mutation_data log there (lots of log when set it to trace level), so one possible way is to put this log at debug or trace level, then it will not impact performance by default. User could enable it when they need such info. Other ways are also welcome.