[
https://issues.apache.org/jira/browse/CASSANDRA-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18100375#comment-18100375
]
Stefan Miklosovic edited comment on CASSANDRA-21539 at 7/30/26 10:17 AM:
-------------------------------------------------------------------------
I think we established a long time ago that system views are free to be changed
/ follow different / relaxed path than system tables on disk, that is why we
just want to nuke it here (that is also probably why we have not mentioned that
fact explicitly here, we were operating as it is a known thing, I guess). We
for sure do not go to create system_views.clients_v2 for this.
was (Author: smiklosovic):
I think we established a long time ago that system views are free to be changed
/ follow different / relaxed path than system tables on disk, that is why we
just want to nuke it here (that is also probably why we have not mentioned that
fact explicitly here, we were operating as it is a known thing, I guess).
> Querying system_views.clients causes a DNS lookup for each unique connected
> client address
> ------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-21539
> URL: https://issues.apache.org/jira/browse/CASSANDRA-21539
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/Virtual Tables
> Reporter: Nivy Kani
> Assignee: Nivy Kani
> Priority: Normal
> Fix For: 7.x
>
> Attachments: ci_summary-1.html, ci_summary.html,
> result_details.tar-1.gz, result_details.tar.gz
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> It looks like queries to the system_views.clients table does a DNS lookup for
> each unique address:
> https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/virtual/ClientsTable.java#L91
>
> Given Java's internal DNS caches, this is really only potentially slow on the
> first query, but we should avoid doing DNS lookups here as a workflow that
> queries this table on each node to collect client information could
> potentially overwhelm DNS this way.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
