[ https://issues.apache.org/jira/browse/CASSANDRA-13665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16420351#comment-16420351 ]
ASF GitHub Bot commented on CASSANDRA-13665: -------------------------------------------- Github user mhartopo commented on a diff in the pull request: https://github.com/apache/cassandra/pull/190#discussion_r178269292 --- Diff: src/java/org/apache/cassandra/tools/nodetool/ClientStats.java --- @@ -0,0 +1,69 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.cassandra.tools.nodetool; + +import java.util.List; +import java.util.Map; +import java.util.Map.Entry; + +import org.apache.cassandra.tools.NodeProbe; +import org.apache.cassandra.tools.NodeTool.NodeToolCmd; +import org.apache.cassandra.tools.nodetool.formatter.TableBuilder; + +import io.airlift.airline.Command; +import io.airlift.airline.Option; + +@Command(name = "clientstats", description = "Print information about connected clients") +public class ClientStats extends NodeToolCmd +{ + @Option(title = "list_connections", name = "--all", description = "Lists all connections") + private boolean listConnections = false; + + @Override + public void execute(NodeProbe probe) + { + if (listConnections) + { + List<Map<String, String>> clients = (List<Map<String, String>>) probe.getClientMetric("connections"); + if (!clients.isEmpty()) + { + TableBuilder table = new TableBuilder(); + table.add("Address", "SSL", "Version", "User", "Keyspace", "Requests"); + for (Map<String, String> conn : clients) + { + table.add(conn.get("address"), conn.get("ssl"), conn.get("version"), + conn.get("user"), conn.get("keyspace"), conn.get("requests")); + } + table.printTo(System.out); + System.out.println(); + } + } + + Map<String, Integer> connectionsByUser = (Map<String, Integer>) probe.getClientMetric("connectedNativeClientsByUser"); + int total = connectionsByUser.values().stream().reduce(0, Integer::sum); + System.out.println("Total connected clients: " + total); + System.out.println(); + TableBuilder table = new TableBuilder(); + table.add("User", "Connections"); + for (Entry<String, Integer> entry : connectionsByUser.entrySet()) + { + table.add(entry.getKey(), entry.getValue().toString()); + } + table.printTo(System.out); + } +} --- End diff -- don't forget newline at the EOF > nodetool clientlist > ------------------- > > Key: CASSANDRA-13665 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13665 > Project: Cassandra > Issue Type: Improvement > Components: Tools > Reporter: Jon Haddad > Assignee: Chris Lohfink > Priority: Major > > There should exist a nodetool command that lists each client connection. > Ideally it would display the following: > * host > * protocol version > * user logged in as > * current keyspace > * total queries executed > * ssl connections -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org